A
Adam
Dear All,
I love pivot tables and the grouping function but I would like to know if I can do this...
I have a large source of data it contains these fields Call ID, Date call raised, date call resolved, Team, then a formula field called 'time taken to resolve' which is Date call resolved - Date call raised.
I then have a pivot table with Team in Row, Time taken to resolve then in Data Count of Call ID.
Because there is so much data I have grouped this by 20. Is there a way where the grouping can be variable and not the one set amount?
Thanks
I love pivot tables and the grouping function but I would like to know if I can do this...
I have a large source of data it contains these fields Call ID, Date call raised, date call resolved, Team, then a formula field called 'time taken to resolve' which is Date call resolved - Date call raised.
I then have a pivot table with Team in Row, Time taken to resolve then in Data Count of Call ID.
Because there is so much data I have grouped this by 20. Is there a way where the grouping can be variable and not the one set amount?
Thanks