Hello,
I'm trying to develop a solution ( which should be a pivot table) where I want to plot Report date month on rows and Action date month on columns. Measure is distinct user count. Now this user count should also be cumulative.
What that means is for action date month March and report date month January, I should get distinct count of users who have reported problem in January and Action is taken in January or Febrauary or March ( distinct count over all 3 months). The final chart should somewhat look like this
Action date | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
Reported date | | | | | | | | | | | | |
Jan | 100 | 200 | 90 | 150 | 45 | 353 | 3434 | 333 | 55 | 5342 | 53 | 4512 |
Feb | | 21 | 2 | 43 | 35 | 54 | 54 | 65 | 65 | 64 | 42 | 345 |
Mar | | | 53 | 5 | 344 | 45 | 55 | 22 | 42 | 54 | 4 | 23 |
Apr | | | | 34 | 32 | 43 | 32 | 43 | 343 | 545 | 43 | 355 |
May | | | | | 43 | 12 | 23 | 4343 | 676 | 887 | 4343 | 63 |
Jun | | | | | | 41 | 22 | 43 | 8 | 98 | 43 | 6643 |
Jul | | | | | | | 44 | 123 | 9 | 45 | 123 | 36 |
Aug | | | | | | | | 42 | 7676 | 32 | 858 | 45 |
Sep | | | | | | | | | 4334 | 32 | 56 | 46 |
Oct | | | | | | | | | | 54 | 668 | 346 |
Nov | | | | | | | | | | | 545 | 46 |
Dec | | | | | | | | | | | | 54 |
Let me know if any one has idea of how to implement this solution.
Thanks for any help in advance.
Amey