Pivot Table

  • Thread starter Thread starter Karen53
  • Start date Start date
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 ?
 
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
Expand and collapse 2
Excel 2010 Pivot Table 2
Unable to Group in Pivot Table 1
Pivot grand total 1
Average of Subtotals in Pivot Table 0
Absolute value 2
Get grand total from pivot table 2

Back
Top