Forum Discussion
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 end date instead?
Thanks for any advise.
Claudia
ClaudiaM1 Varsågod!
11 Replies
ClaudiaM1 Perhaps like in the attached example? I grouped by Q2 and then dragged the new field "End (Quarter)" to the top of the list in the Columns area.
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?
