Custom Dimension on Partial Sum

[Anonymous]

Hello,

I have a Format Problem on a partial Sum, because when i want to change the background or the fore color, it affect only the expression:

Pivot Table:

Custom Format Cell:

How can i manage that please ?

Thanks you in advance for your help.

Sébastien.

[sunny_talwar]

Can you try playing around with this?

UPDATE: not sure if it will do anything, but see if that helps

[Anonymous]

I tried, it affects all but not the Partial Sum 😕 :

[sunny_talwar]

Ya, it doesn't seem to be working for subtotal unfortunately.

[Anonymous]

Okay

[marcus_sommer]

You could color your partialsums with an attribut-expression (in each expression/dimension) like:

if(match(Dimensionality(), 0,1), green())

- Marcus

[sunny_talwar]

But you can use if statement with SecondaryDimensionality() to get this to work.

[sunny_talwar]

Marcus‌ I think he will need SecondaryDimensionality() here:

Pick(SecondaryDimensionality()) + 1, Green(), White())