Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

 Back


Tips & Tricks - September 2019

The following Tips % Tricks are the ones presented during User Group meetings in September 2019.

Mapping User Dimension member to multiple areas in Area map

Usually you will just want to map a single dimension member, e.g. a Zip code, to a single corresponding area in an Area map.

However, sometimes you just need to combine some areas in the Area map into larger groups, e.g. to reflect a customized grouping you may have made with User Dimensions.

This video shows how single dimension members (from a User Dimension) are mapped to multiple areas in an Area map.


Multidimensional Subtotals

When you are combining two or more dimensions, or two or more attributes from the same dimension, to design a custom hierarchy in a crosstab, you may want to useMultidimensional Subtotals.

E.g. if you have Countries as the first level dimension and Store Types as the second level dimension, then you may have the same Store Type represented across all countries. While TARGIT perfectly displays subtotals for the Countries (because they are on the top level), you may also want to know the subtotals for the Store Types - i.e. the sum of each Store Type across all Countries. For this, you will need to enable Multidimensional Subtotals.

Once enabled, you will also be able to refer to the Multidimensional Subtotals in TARGIT calculations - opening up for even more usefulness.


Highlight Empty Cells

Most TARGIT Designers have experienced this: You want to highlight rows or columns or individual cells on with an agent with a specific rule - but, unfortunately, the impression is more or less ruined because blank or empty cells seem to not follow this rule.

The trick is to "duplicate" the cells. Rather than being blank, the duplicated cells will now contain a value (zero) - and that is all that is required for an agent to actually work on that cell.


  • No labels