In the worksheet when we use the "Show Pivot Total" it's always doing the operation that was configured in the Data Model (ex: MAX), but we would like sometime to do a Max like it should be for all the row but when we calculated the total by column (the pivot)
We would like to summarize them instead (so a SUM of the MAX). Would be really nice if we could specify the summarization option (Max, Min, Avg, Sum, etc...) when we choose the "Show in pivot total" option.
Thanks.