Arrange the data

[Pr]

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

[cjaneczko · Accepted solution]

Cross tab the data and group on Quarter and Week Number. Then set the headers to Year with an Aggregation Sum on Count.