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?
Riny_van_Eekelen Hi Riny again, just a quick question, if I want to show Quarter in the filter as label instead of SLUTDATUM (end date), as the revised PT you sent me, is this possible? is it also possible to show Start date and End date in headings as shown below?
ClaudiaM1 Like so? (see attached)