How to get the results in the below format for count of calls, each week (13 in total) of each quarter (4 in total) for each year (3 years)
Year 1 Year 2 Year 3 Count of calls
Q1 Week 1(number)
Week 2
Week 3
-upto week 13
Q2 Week1
Week 2
Week 3
-upto week 13
Current data:
Year Quarter Week number Count
Solved! Go to Solution.
Cross tab the data and group on Quarter and Week Number. Then set the headers to Year with an Aggregation Sum on Count.