Pivot Table

K

Karen53

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 ?
 
R

ryguy7272

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---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can set dynamic pivot table ONLY when I have enough data point 1
Unable to Group in Pivot Table 1
Excel 2010 Pivot Table 2
Expand and collapse 2
Absolute value 2
Get grand total from pivot table 2
Average of Subtotals in Pivot Table 0
Pivot table multiple filters 2

Top