Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you try playing around with this?
UPDATE: not sure if it will do anything, but see if that helps
I tried, it affects all but not the Partial Sum 😕 :
Ya, it doesn't seem to be working for subtotal unfortunately.
Okay
You could color your partialsums with an attribut-expression (in each expression/dimension) like:
if(match(Dimensionality(), 0,1), green())
- Marcus
But you can use if statement with SecondaryDimensionality() to get this to work.
Marcus I think he will need SecondaryDimensionality() here:
Pick(SecondaryDimensionality()) + 1, Green(), White())