Forum Discussion
Dynamic Percent total based on date and store
Hi I need help with creating measures. My data looks like the follows: Store Employee Date Sales A Joe 10/1/2019 2 A Ron 10/1/2019 3 A Amy ...
Hi this function does not work when I drill up to the month. For the Month total, I get the same value as the total for the day.
This is the result I want to get when the data is drilled down to the day
Store | Employee | Date | Sales | Daily Sales Sum | % of Daily Sales |
A | Joe | 10/1/2019 | 2 | 5 | 40% |
A | Ron | 10/1/2019 | 3 | 5 | 60% |
A | Amy | 10/2/2019 | 1 | 4 | 25% |
A | Joe | 10/2/2019 | 3 | 4 | 75% |
B | Tammy | 10/1/2019 | 4 | 6 | 67% |
B | James | 10/1/2019 | 2 | 6 | 33% |
THis is the result I want when I drill up to the month
Store | Date | Employee | Monthly Sales | Monthly Sum of Sales | % of Monthly Sum of Sales |
A | October | Joe | 5 | 9 | 55% |
B | October | Tammy | 4 | 6 | 67% |
Thanks
Ashish_Mathur
Super User
Super User