Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have a pivot table that shows data groups in rows, months in columns and "COUNT(Records) * Price" in expression. When I check partial sum for months (columns) I get it right but when I check partial sum for data groups (rows) pivot doesn't show it. I've put Price dim into SUM(Price) and got the partial sum but incorrect (att. screen shot). However, when I change pivot to bar chart partial sums come up correct.
Please advise how to fix it.
BR,
Przemek
did u solve this? I have same issue