'Show items with no data' ignores filters - need a workaround

I'm happy to be corrected on this, but you can either show items with no data which ignores the filters, or you can have the pivot table accept the filters which means you can't have a result displayed simply to say it has no results.

So in short I don't believe you can do what you are asking with a pivot table.

But every day's a schoolday so here's hoping

That seems... stupid! If I can't make this work then I have to find a work-around of sorts. Next to my rolling 30 days pivot is a rolling 6 months pivot, and I can't have both pivots with a different list of accounts in it as you can't then read across one line for the same account.... I also can't have all customers and all accounts showing on the same pivot, as I have about 10 customers with around 200 accounts I need to account for (each customer is set up on a different sheet).

I had this all set up and working with manual tables all formulated to reference all sorts of pivots on a separate sheet, but this made the file size massive, and it was taking me hours to update everything when a new customer/account was added, and there were too many areas where a slight spelling error meant incorrect reporting. I don't want to have to revert back to this old style!

Is the pivot being used by anyone to filter or slice the information in anyway? or just being used because of the file size issue you had before?

Not by the end user, no - for them it's just tables of information that have already been filtered by me. Most of the data is in pairs, so one table for numbers, then a 2nd table for percentages (it's how they want it displaying, not my choice). So for example there are tables for jobs created, jobs delivered, jobs delivered on time, jobs cancelled by customer etc. Roughly there's 11 tables in total.
I was to consolidate the 10 sheets I had into one, with a slicer for the customer name. Then they can simply choose which customer to look at, which will save me duplicating sheets and save on file size. I also wanted to remove the need for so much formula as it was introducing (human-made) errors when changes were made (almost every other day).

Bump - still desperately searching for a workaround for this issue - any suggestions would be immensely appreciated!