Apologies if this has been asked before somewhere, but I'm scratching my head with this and no amount of searching gives me a solution I can use (maybe I'm not using the right search terms...?)
Anyway - I have a pivot based on job data for customers (one line of data for each job). Each customer has several sub-accounts. I am trying to create a pivot for one specific customer, to display all their accounts and sum all of their jobs up. My issue is that one of these accounts currently has no jobs for the time frame I'm looking at (rolling 30 days), and so this particular account is not showing on the pivot (totally makes sense). I need this account to appear so that it shows it has no data, so I've gone into the pivot settings and checked 'Show items with no data', but then the pivot shows me ALL accounts for ALL customers, and ignores the filter I have set for the customer I want! I just don't get it! I've tried re-creating the pivot from scratch in case I had things checked/unchecked I wasn't aware of, and still get the same issue.
Anyone come across this before and know how to make it work? Seems like it's not working as intended to me
Bookmarks