Custom Calculation sum of dimension repeated for every line in crosstab
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?
1
Comments
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:
This calculation will look for values on the level of the third dimension in your crosstab.
BR / Ole
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.
Please sign in to leave a comment.