Excel 2019 Pivot

[PWD]

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

 

[PWD]

Just another anomaly, is that I changed "General Medical Practitioner" to "G.P." in the data but the Pivot Filter still offers that as an option. I've attached a couple of screenshots to show what I mean.

Many thanks,
D€$

 

[PWD]

Pivot Filter.

Many thanks,
D€$

 

[combo]

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

 

[PWD]

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