COUNT(TOTAL <dim1,dim2,dim3> value)
i want to do this. only problem is that one of the dimensions is variable, because i'v created a dimension with serveral dimensions in it.
users can cycle these dimensions in the pivot charts. i need that group dimensions in the COUNT TOTAL formula because otherwise i get the wrong numbers in that expression.
sum(TOTAL <[<<ProductCycle]> Sales)
why is this working? [ ] i can understand but why <<
i would haved never came up on this syntax 🙂 is this commen use?
Thanks alot btw. .. i own you a drink
<< is just part of the name of the dimension group and is not part of the syntax. The important part is the set of brackets [ ].
Note: << is short of cyclic group and >> is short for drilldown group though I prefer to use clGroupName and drGroupName.