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'...

Sometimes, data in an Excel file is not structured ideally to be imported by Prism. Occasionally, the data is presented in a Pivot-like manner that is more readable and takes up less storage space. A good example for this is marketing survey data that often comes in this form: Image 1 - Marketing Survey...