ParamQuery grid support forum

General Category => ParamQuery Pro Evaluation Support => Topic started by: EPM Solutions on April 16, 2021, 05:07:23 pm

Title: How can we show values of an calculated Column in Pivot Mode?
Post by: EPM Solutions on April 16, 2021, 05:07:23 pm

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?

Title: Re: How can we show values of an calculated Column in Pivot Mode?
Post by: paramvir on August 09, 2021, 09:41:06 pm

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