ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to open/consolidate details for multiple rows in a PivotTable (https://www.excelbanter.com/excel-discussion-misc-queries/152394-how-open-consolidate-details-multiple-rows-pivottable.html)

Jamie W[_2_]

How to open/consolidate details for multiple rows in a PivotTable
 
I have a monthly/weekly consolidated list of all customer support cases
opened for my employer, and the task is to aggregate these by customer name,
sort by descending, and ultimately extract all customers with a corresponding
case qty =5 and sort those by case type/problem. Is it possible to either
do all this in one pivot table *or* create a pivot table of a pivot table to
take the final step?

Thanks,

Jamie


All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com