Hello Team,
I am trying to create a pivot table with the following fields: Source, Year, Month, Measure. I would like to generate the output in an excel format to visualize the year as separate sheets, maintaining the pivot format with source on the rows and the year in months on the columns. However, once the pivot table has been generated, even using a recurring group, the output generates the same table on two different sheets without separating the data by year. Is there a way to generate such a table?
Thanks