I am trying to create a custom calculation to limit this crosstab visibility by the Customer Total where the total for the customer is greater than $5000.
sum(d1, all(v,c), m1) isn't quite cutting it- what is the syntax to repeat the total for each customer every line in the crosstab under that customer dimension?
Ole Dyring Hi Trevor,
I cannot tell from your screenshot if you are having six individual dimensions on the vertical axis or if any of these dimensions are expanded hierarchies. So I am guessing a little in the blind here.
Assuming it is six individual dimensions, you may try something like this:
sum(d1, 0(l(1,1,1,0,0,0)), m1)
This calculation will look for values on the level of the third dimension in your crosstab.
BR / Ole
Trevor Hill It is two expanded 2-level hierarchies, Showroom expanded to Sales Reps and Customer expanded to show document number. I want to repeat the Customer total for every line under that Customer number.
Comments
2 comments