Author Topic: How can we calculate a grand summary row as custom calculated in Pivot mode?  (Read 1687 times)

EPM Solutions

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 182
    • View Profile
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.
« Last Edit: April 16, 2021, 04:21:12 pm by EPM Solutions »