Having a pivot table with data in it is not always enough. Sometimes, you want to display different colors for different value ranges.
In order to see coloring by values (Threshold), I will create a new custom string field [Indicator] in the ElastiCube Manager.
ifstring(([Amount]>50), 'Green', 'Red')
Now open PrismCubed, create a new Pivot and add Customer and Indicator dimensions on the rows and Amount measure on the columns.
Using the span selection on a member, select the Red member such that all Red members and Amount values will be selected and set its back color to red.
Do the same for the Green member.
Final step is to minimize the Indicator field such that it won't be visible.
