ParamQuery

General Category => ParamQuery Pro Evaluation Support => Topic started by: EPM Solutions on April 16, 2021, 03:38:32 pm

Title: How can we calculate a grand summary row as custom calculated in Pivot mode?
Post by: EPM Solutions on April 16, 2021, 03:38:32 pm
Hello Team,

We a have paramquery grid with some numerical records with Budget Class (column) = "Budget" and some with Budget Class = "Portfolio" .
We are calculating the summary row as Total Budget remaining = Sum of Portfolio records - Sum of Budget records in Normal Mode of Grid.

Now when we are tying to calculate Total Budget remaining in Pivot mode of Grid then it is not calculating and showing blank in grand summary row.

Can we able to custom calculate it in Pivot mode too ? Please help us to resolve the issue.