anything in Excel...

It's Excel-o-lozy...

Tip - Filter Pivot Table by Values in Data column

Yes, Pivot Tables can be filtered. Easy to filter first column or even sub-groups with text in it. BUTTT... How to Filter Data column where data is displayed as "Sum" or "Count"??? Easy.... Filter the Text column that comes immediately before "Data Value" column as "By Value" and put any criteria say ... More than, less than, equals etc and see the result. It's possible even through applying auto-filter say Normal Filter on the Pivot Table... But problem is that It will hide row of "Sub totals" if that is within the applied criteria... Didn't get? Get a Pivot and Try yourself...

0 comments: