Hi Pivot Table Geru(s)
Help please! Can anyone tell how to further summarise pivot table data where each row already has sub data, and there are many lines with similar titles as sub sections, so that the Pivot table can summarise all rows commencing with say "Census", to give 4 or 5 main topics to make the table more visually acceptable? Can queries be set against initial Pivot Table results to summarise the data further still? Many thanks
Help please! Can anyone tell how to further summarise pivot table data where each row already has sub data, and there are many lines with similar titles as sub sections, so that the Pivot table can summarise all rows commencing with say "Census", to give 4 or 5 main topics to make the table more visually acceptable? Can queries be set against initial Pivot Table results to summarise the data further still? Many thanks