Expression

[Shane]

Hi

Im looking to set colour for my pivot table but Only on the totals. Is there a specific expression for this? 

[JGMDataAnalysis]

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()))