Forum Discussion
Solved
Excel Pivo table
Hi, I have a pivo table with two columns with date, start date and end date, I want to group by quarter on end date but the table groups by start date, how do I change it so it groups quarter on ...
ClaudiaM1 Varsågod!
Riny_van_Eekelen , Thank you for your answer, although I can't manage to change so that the source data for grouping quarterly retrieves data from end date instead of start date, see attached table.
ClaudiaM1 Not being the user of the data, it's hard to imagine what you are trying to show, but perhaps the attache revised PT is what you need. If not, can you visualise how you would want the PT to look like?