Forum Discussion
Matrix Grand Total for Column Disappears when Moving Down a Level
After adding the July update, I am having an issue with the grand total of columns in a matrix.
When viewing the report rows for the matrix at the top level of Client, the Billable and Hours total populate at the bottom of the dataset and are 'frozen' there as the user scrolls through the lines.
However, if the user clicks the "Show Next Level in Hierarchy" button, it will move down from Client to show the jobs, but the grand total at the bottom disappears (even if you scroll to the bottom.
"Expand to Next Level" works as normal, and the totals remain at the bottom of the matrix.
I just confirmed with a number of previously published reports that the "Show Next Level" keeps grand totals at the bottom.
Is this a bug or did they bury a setting somewhere?
Hi connork,
When viewing the report rows for the matrix at the top level of Client, the Billable and Hours total populate at the bottom of the dataset and are 'frozen' there as the user scrolls through the lines.
However, if the user clicks the "Show Next Level in Hierarchy" button, it will move down from Client to show the jobs, but the grand total at the bottom disappears (even if you scroll to the bottom.
By my test, I cannot reproduce the issue you described. Here is my test output.
If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
1 Reply
Hi connork,
When viewing the report rows for the matrix at the top level of Client, the Billable and Hours total populate at the bottom of the dataset and are 'frozen' there as the user scrolls through the lines.
However, if the user clicks the "Show Next Level in Hierarchy" button, it will move down from Client to show the jobs, but the grand total at the bottom disappears (even if you scroll to the bottom.
By my test, I cannot reproduce the issue you described. Here is my test output.
If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry