Hi,
This is probably really easy but my brain is fried after a long week..
I have a crosstab built from relational data, where one of the data items on the rows is a top 80 % calculation (i.e. the data item is toppercent([Model].[Query Subject].[Field],80,[Cost])
I can't seem to create a sub-total to add onto the crosstab after it to show the sum total of all the displayed Fields.
Help!
By the way, clicking on the field and hitting Aggregate > Total doesn't work :)
Thanks in advance
Fixed it...
When I used the summarise > total function to calculate a total for the Top 80% calculation, it was automatically generating the calculated column...
total(currentMeasure within detail [Top 80% Column])
I had to change it to...
total(currentMeasure within set [Top 80% Column])
Thought I'd post this in case anyone wanted to know the answer :)