There are some data in an excel file for which I have made a pivot table. In the attached example, there are some labels viz. Data 1 & Data 3 which have multiple values unlike the others which have unique ones. I need to filter or sort the data in the pivot such that these multiple instance ones are visible together for easy identification.
2 Answers
Thank you all for your responses! I figured it out. So as per the example and attached screenshot, I added the Label1 (Data) in Rows, Label2 (Values) in Columns and then Label2 in Values. So this got me the bifurcation of the Grand Total which I then took below the pivot table so as to take the Counts of the Values (Column marked orange - Instances). Then I sorted them descending so as to whichever Labels had more than 1 count.
Have you considered creating a 2nd pivot table with the same data, But have the Values filtered first then the Data?
