Dimension Limits Totals label

[danielact]

I have a straight table, and I'm using the Totals feature in the Dimension Limits tab to show subtotals. I'd like to customize the label to pull in the value of the dimension. Here's an example of what it shows, and then what I'd like to get to:

Department     Contract #     Cost    

Legal               111A               1000

Legal               112A               2000   

Legal               113A               3000

Legal               Total               6000

Sales               211A               5000

Sales               212A               6000

Sales               213A               3000

Sales               214A               4000

Sales               Total               18000

I'd like to get to this:

Department     Contract #          Cost    

Legal               111A                    1000

Legal               112A                    2000   

Legal               113A                    3000

Total for Legal (3 contracts)       6000

Sales               211A                    5000

Sales               212A                    6000

Sales               213A                    3000

Sales               214A                    4000

Total for Sales (4 contracts)        18000

Any ideas on how to do that?

[MEllinghausen]

hey,

you can try under PräsentationTAB "description of Suptotales"?  in german 'Bezeichnung für gesamtwerte' like this formula

='Total for ' & department & '( ' count(contracts) &')'

Marcus

[Gysbert_Wassenaar]

Unfortunately that's not possible. You get only one label for all the totals from the Show Totals option of the dimension limits. Any expression you use in the label won't be able to use the charts dimensions to aggregate on.

[MEllinghausen]

Gysbert you are right, I try It out.

Marcus

[danielact · Accepted solution]

I actually figured out how to do it. This formula might not work exactly for my example above, but here's what I did:

I set up Department as a Dimension, then hid it. I also set up an Expression for Department, with this formula:

if(Dimensionality()=2,'Total for '&Department&' = '& Count(ContractNum),if(Dimensionality()=0,'Grand Total = '&Count(ContractNum),Department))