Determine if alternative Column Dimension is Active on the Pivot Table

[Scott2]

Hi All

I'm hoping you can help me with the following query. 

I have an AgeBucket column dimension in my Pivot Table. Depending on the age bucket I colour the measure accordingly as Red, Amber or Green. This all works fine.

I have now created a new AgeBucket called AgeBucketNew as an alternative dimension. The user can swap the AgeBucket column dimension for AgeBucketNew column dimension via the Pivot Table Setup button on the Dashboard.

I want to be able to colour the measure based on AgeBucketNew and AgeBucket. To do this I think I need to know whether AgeBucketNew or AgeBucket is active on the Pivot table. (Only 1 would be used at a time). 

Any suggestions? 

thanks

Scott

[Scott2 · Accepted solution]

=GetObjectDimension actually worked fine once used in an if statement in the expression.