Issue creating subtotal of toppercent calculated column

[jonathan.webb@raytheon.co]

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

[jonathan.webb@raytheon.co]

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  :)