Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a pivot table where i have several rows for a customer like
Customer , Line , Sales
A,1, 100
A,2,400
A,3,500
B,4,100
B,5,100
How can i calculate total by customer on the pivot that is repeated for each row ? like follow
Customer , Line , Sales, total
A,1, 100, 1000
A,2,400, 1000
A,3,500, 1000
B,4,100, 200
B,5,100, 200
Thank you
try to create a measure for total as :Sum(Sales) and dimension for customer