I am trying to create a pie chart of percentages on a dashboard that is the grand row total. The closest I can get is a column report.
Here is a mock up of data and pie chart from excel showing desired dashboard pie chart information.
Here is the closest I have been able to get - using summary report with formula fields to calculate percentages, and creating a bucket field row grouping that has only one row value named Asset Class that all rows match. Any way to do this in a pie chart in a dashboard? This solution is not a grand row summary but gets to the same value by reporting only 1 row