Forum Discussion
Subtotal issues in a matrix
Hello all,
I've searched for similar issues but can't find anything quite the same.
I've a matrix and for conditional formatting I've added icons based on rules. They work for for when I drill down into each section. I selected values only not subtotals.
However when it's at the top view minimised it's showing subtotals for each row. Even though I've not selected that option ? Pics below for clarity.
When I drill down the total icons disappear like they should. Strange !
Any help much appreciated.
Cheers.
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.
5 Replies
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.
Thanks very much. Worked a treat. For your total revenue part on the measure I couldn't work out why the one I needed wasn't popping up. Then realised it's a sum of a column so typed in sum [ and there it appears. Jackpot.
Cheers
