ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot Table (https://www.excelbanter.com/excel-programming/409559-pivot-table.html)

Karen53

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

ryguy7272

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