Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Im looking to set colour for my pivot table but Only on the totals. Is there a specific expression for this?
You can use the Dimensionality function to apply color to the measure cells based on the position of the dimension. For example, for the values of the Grand Total, the Dimensionality function returns 0 (zero).
The background color expression associated with the measure of the pivot table in the screenshot is as follows:
If(Dimensionality() = 0, LightBlue(), If(Dimensionality() = 1, LightCyan()))