Recently we have migrated from 220.127.116.11.131017 to 18.104.22.168.150120 version.
In version 22.214.171.124.150120 there is one report which has pivot view in it. For that report for null values Grand Total is showing 100.0%.. The required result is it should display same null value.
For the measure column 'Percent off'/'row' is selected for 'Show data as'.
This issue is only coming when we have above 'Percent off'
When we have 'Show data as' 'values' zero is coming up in Grand total which is expected.
Please suggest if any workarounds are there for this issue.
Add one more criteria to the report(combine similar request) and copy the parent criteria. Hard code Grand total and use it as grand total row.