When working with a Pivot Grid and you want to replicate a calculation that was previously done in a Cube View via a calculated column or CalcScript, you can leverage the Pivot Grid’s built-in calculations. In your Pivot Grid properties, go to Values > Calculation, choose a calculation type like Percentage of Difference, then select Custom.
From there, you can enter a custom expression such as: ToDouble(Sum([Amount]) / Lookup(Sum([Amount]), -1))
This particular example divides the current column’s total by the previous column’s total (using -1 to reference the previous column), effectively mimicking the ratio or margin calculation you had in the Cube View’s CVC column. Of course, you’ll need to adjust the expression based on your exact scenario and which measures you’re comparing.
