My pivot table has account numbers as the row label and the COUNT of Account numbers as the values. The Count of Account number has a value for the amount of times the account is repeated in the source data. The grand total for the pivot table shows the SUM of the values of Count for Account Number instead of the COUNT. Is there a way to have the grand total row use COUNT instead of SUM ? Example of data below (would like to Grand Total to show 6)
-- removed inline image ---
-- removed inline image ---