ituser2008
MIS
I have a pivot table layout liked the following. Is anyway when I double click on the items counts listed under each aging bucket and it will show the detail for the age bucket and the user I clicked on?? For example, if there are 2 items listed under age 1-30 bucket with user Mary, when I double click on the 2 items, it will create another tab and shows the detail for Mary?? Is it possible to do it with a pivot table?? Any help will be greatly appreciated.
System name and User as the Rows on the left
And Aging bucket listed on the column as the following:
Age 1-30, Age 31-60, Age 61-90, Age 91-180
System name and User as the Rows on the left
And Aging bucket listed on the column as the following:
Age 1-30, Age 31-60, Age 61-90, Age 91-180