Forum Discussion
Need for a pivot table in the subtotal row the sum of column with averages.
Hello, I need some help with totals and subtotals in a pivot table I want that the subtotal row of a column with averages the sum is of the items and not the average of the items. I attachment y...
Good one SergeiBaklan
Another way to write the same measure...
Sum by day MD Average2 :=
SUMX (
VALUES ( _C70_ALMM_Extended[RF] ),
[MD Average]
)
Thank you for the answer. It's also nice to get more than one solution.
I understand the solution but I'm still trying to apply to another sheet.
I understand the solution but I'm still trying to apply to another sheet.