![]() |
Pivot Table
Hi,
I have a pivot table showing data over 4 months. Is it possible to set the pivot table to only show those lines where the 'Grand Total' is greater than 1 ? -- Thanks for your help. Karen53 |
Pivot Table
Double-click one of the items with a down arrow. Click advanced. You have
AutoSort options, as well as 10 AutoShow options in here. Fiddle with that for a minute or two and see if you can get the results you want. Regards, Ryan--- -- RyGuy "Karen53" wrote: Hi, I have a pivot table showing data over 4 months. Is it possible to set the pivot table to only show those lines where the 'Grand Total' is greater than 1 ? -- Thanks for your help. Karen53 |
All times are GMT +1. The time now is 07:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com