Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=GetObjectDimension actually worked fine once used in an if statement in the expression.
=GetObjectDimension actually worked fine once used in an if statement in the expression.