Forum Discussion
Subtotal issues in a matrix
Hi Coppercrutch
How many row categories do you have? The only time the upper-level hierarchy doesn't show icons when the 'values only' option is selected is when you've drilled into the lowest level of the hierarchy. Until then, the upper-level hierarchies are considered values. You will need to write another measure to check whether the lowest level in the hierarchy is currently in scope and return a value if it is. In the screenshot below, ISINSCOPE will return true only at the geo level, thus it returns blank for the year and category row categories, resulting in no icons.
Hi Coppercrutch
How many row categories do you have? The only time the upper-level hierarchy doesn't show icons when the 'values only' option is selected is when you've drilled into the lowest level of the hierarchy. Until then, the upper-level hierarchies are considered values. You will need to write another measure to check whether the lowest level in the hierarchy is currently in scope and return a value if it is. In the screenshot below, ISINSCOPE will return true only at the geo level, thus it returns blank for the year and category row categories, resulting in no icons.
Ok thanks I will give that a go. Quick query - What exactly do you mean by the "geo" level ?
8-10 row categories
Cheers !
Geo is the lowest level in the hierarchy in my example.
Ah ok I get you. So for me it will be the individual resource. So this way I'm creating a measure based on this resource column.
And depending on the result I then use this measure rather than the resource column data to define the conditional formatting rules.
Thus it won't show for the totals.
I might get food at this stuff one day : 😁
Will give that a go and let you know. Thanks for the help.