I want to display all the months (ResponsePeriod in this case) as columns and Month KPI as values for those columns and i have few other columns as headers in the table.
My Requirement is in place of Grand Total, i should be able to show the average of all these months. I have calculated the average measure and placed in values. However, that displays against each and every month as shown below.
expected outcome is :
Month 1 Month 2 Month 3 Month 4 Average
Any help would be greatly appreciated.
From your description, it seems the month column is placed in Column bucket of the matrix visual and there are two columns/measures Month KPI and Average placed in Values bucket, right?
Based on my test, as the Average is the Value of the matrix, it will display on each column group value level and column group total level, it's not possible to remove the Average columns on column group value level.
To work around the issue, we can set the Field Formatting for the measure/column Average like below to make the Average values in column group total invisible.
Hmm.. this is a workaround i understand. Thanks for the response. But will not be a solution for my client.
Do you think we can have a custom visual built for the same?