dynamic subtotal

[marcorizzo]

I've got a very simple pivot table with a grafic classification of the expression "importo totale" with 8 colours. (file trial)

How can I've a sub-total of difference colours ?

Thanks

[marcus_sommer]

I suggest you creates within the script an additionally main-category to your sub-category and used then the partial-sum feature from the pivot-table. If this isn't suitable you could also create a Calculated Dimensions.

- Marcus

[luciancotea]

You can change the formatting of the cells, depending on the aggregation level, using DIMENSIONALITY() function.

Go to Expressions, expand the expression and change the "Background color" to something like:

=if(Dimensionality() = 1, red(), Blue())