L
lj
I'm working with a pvt table in excel. Right now there are several
fields in the pvt table, including the month different entries are made
and the account that made them. When i hit the show detail button in
the pivot table i get the detail all of the entries grouped by month
and by account on a separate sheet. I want to continue to do this, but
i want to also be able to get a second view where i hit the show detail
button and only see the detail grouped my account (month is either
hidden or totally removed from this list of data in the pvt table and
the rows that composed the different months is aggregated. Is there an
easy way to do this without removing the month column from the detail
sheet, creating a second pvt table, and then hitting the show detail
button again?
fields in the pvt table, including the month different entries are made
and the account that made them. When i hit the show detail button in
the pivot table i get the detail all of the entries grouped by month
and by account on a separate sheet. I want to continue to do this, but
i want to also be able to get a second view where i hit the show detail
button and only see the detail grouped my account (month is either
hidden or totally removed from this list of data in the pvt table and
the rows that composed the different months is aggregated. Is there an
easy way to do this without removing the month column from the detail
sheet, creating a second pvt table, and then hitting the show detail
button again?