How can we show values of an calculated Column in Pivot Mode?

[EPM Solutions]

Hello Team,

We have % Spent column (calculated as % Spent = Cost (H) / Budget (F) in rendering function) in paramquery grid.

% Spent is dependent on Budget & Cost Column.

Now when we are trying to see it in the Pivot mode then it is showing 0 in each cell of % Spent column instead of calculating its value its value.

 Can You please help me to give a solution for it?

[paramvir]

Please check this example: https://paramquery.com/pro/demos/pivot_formula_col