×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Excel 2019 Pivot

Excel 2019 Pivot

Excel 2019 Pivot

(OP)
Good morning, I hope this is me being really, REALLY thick! I'm trying to limit the output in a Pivot Table to values greater than n. The attached workbook is just a model of a much larger workbook that I created earlier this week where I was able to use the Value Field filtered 'Greater than...' n. My data changed the next day and I had fewer records but then couldn't get any records returned when I refreshed the data in the Pivot Table. What it appeared to be doing was filtering on the Totals row only - I deduced this by putting in a much smaller number. I have used the actual 'Filter' on the attached workbook, but that has involved selecting every value > n manually.

Please, please PLEASE get me out of this!

Many thanks,
D€$

RE: Excel 2019 Pivot

You can filter only row or column fields. The filter is removed if filtered field is moved to filters area.
However, you can:
1) temporarily put days as row field,
2) group by days: mark the beginning as 54.9, leave upper limit automatic, set step big enough to cover all expected data,
3) drag grouped field to filters area and untick unnecessary ranges.

combo

RE: Excel 2019 Pivot

(OP)
Thanks Combo, it just strikes me as REALLY strange that I managed to cross the x & y co-ordinates and achieve what I wanted earlier in the week - although I'll admit that I probably put this in there, did something, moved something somewhere else and Heaven knows what!! I'm finishing for the day and we've got a Public Holiday tomorrow to celebrate VE Day, so I'll come back to this on Monday.

Many thanks,
D€$

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close