In powerpivot, I have a pivot table setup of sales orders per customer per month linked to a date table.
Of 40 customers, I have a slicer that filters per customer and tells me current sales per month of that particular customer.
If I unfilter the slicer, then the sales per month does correctly show the total sales for that month.
Total cust sales for per month :
Months Rev
5/1/2015 568K
6/1/2015 718K
But I would like to click on a certain customer in the slicer and not only tell me the sales but customer sales as a percentage of total sales for that month.
A cust sales for per month :
Months Rev RevT %_Rev
5/1/2015 49K 568K 9%
6/1/2015 70K 718K 10%
My problem is when I filter for a certain my pivot table only gives me the following :
Months Rev
5/1/2015 49K
6/1/2015 70K
I have tried the DAX filter of All(sales[revenue]) but that gives the entire sales for all months.
Can someone please help me with the RevT DAX formula ?
If you need any clarification , please let me know.
Bookmarks