Forum Discussion
Excel Pivo table
ClaudiaM1 Varsågod!
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?
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?
