Hide Value at Total and Parent Level
Brand Points is a calculated column.
I want to show it at the Report Code Level (for example, what's to the right of the bottom blue box). However, I do not want to show it at the Brand Level (for example, what's to the right of the top blue box) or at the Total level (bold rows). How can I modify visibility to only show the result of the calculation for Report Code Level?
0
Comments
I think I got close by using the L2 modifier. But not sure where to put the "fourth Parameter" for undefined?
Below does close to what I wanted when report codes are expanded, but shows "undefined" when looking at the Brand Level.
Hi Karl,
There are too many unknown things that I can't see in order to investigate this properly.
Please, can you show a screenshot of the crosstab in Define mode?
BR / Ole
Sure, thanks Ole. I got pretty close, but would still like to hide the "undefined" and hide the "Brand Points" in the Total line if possible.
For example, would like to hide "Undefined" when unexpanded:
When expanded, and using the Advanced Calculation I posted yesterday, this looks pretty close to what I want.
I like how it doesn't show undefined, it doesn't show grand total brand points, and it doesn't show total brand points for certian brands where some have a 5 and some have a 10 (summing or averaging doesn't make sense here, so blank is good).
But I am uncertain why it shows the 10 highlighted in yellow. Would be ok to just hide grand total and subtotal Brand Points if that is possible. Not the entire member, just the Brand Points value.
Hi Karl,
Please, have a look at this screenshot:
In Table 1 I have a two level hierarchy. No of Sales is my m1. 'Brand points' is calculated as sum(d1, 0(l2), m1, 0). (I am not using 'Copy m1' (sum(d1, 0,m1) for anything - it is just there for reference.)
Table 2 is simply Table 1 collapsed.
In Table 3 I have added a visibility agent, working on the 'Brand points' calculation. The condition is 'Hide value' when allcount(d1, all(c), m1) <> 0.
In Table 4 I have furthermore worked with number formatting of my 'Brand points' calculation. In 'Advanced format', for Zero numbers, I have specified 'Min number of digits' = 0.
I hope this will inspire you to get your desired result.
BR / Ole
Awesome, thank you Ole. I was close, but this got me exactly what I was looking for!
Please sign in to leave a comment.