A
Adam
Hi All,
I have a report I need to create which goes as follows.
I have a data list of around 56k records.
The rows contain this; category 1, category 2, category 3, call id and
Date
I've created a pivot table with Cat1, cat2, cat 3 on the row area,
Count of Call ID in the data area and date in the column area (this is
grouped by Month).
I'm looking at the months of Mar, Apr and May. I want to sort it, in
descending order, by the difference of 'Count of Call ID' there is
between Mar and May.
If I cannot perform the calculation in the pivot table, is there a way
of ungrouping the fields in a pivot table?
So rather than it showing as below:
Cat 1 Cat 2 Cat 3
Cat 2 Cat 3
Cat 2
It shows as:
Cat 1 Cat 2 Cat 3
Cat 1 Cat 2 Cat 3
Cat 1 Cat 2
Many Thanks
Adam
I have a report I need to create which goes as follows.
I have a data list of around 56k records.
The rows contain this; category 1, category 2, category 3, call id and
Date
I've created a pivot table with Cat1, cat2, cat 3 on the row area,
Count of Call ID in the data area and date in the column area (this is
grouped by Month).
I'm looking at the months of Mar, Apr and May. I want to sort it, in
descending order, by the difference of 'Count of Call ID' there is
between Mar and May.
If I cannot perform the calculation in the pivot table, is there a way
of ungrouping the fields in a pivot table?
So rather than it showing as below:
Cat 1 Cat 2 Cat 3
Cat 2 Cat 3
Cat 2
It shows as:
Cat 1 Cat 2 Cat 3
Cat 1 Cat 2 Cat 3
Cat 1 Cat 2
Many Thanks
Adam