Forum Discussion
Subtotal issues in a matrix
- 1 year ago
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.
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