I have created a pivot table where I want to add different items together, which could vary month by month. What I mean, for example, is that one month there could be 'QPR' and 'QUT' and therefore all items should show in this field. Another month only 'QPR' could show, but I would still want a figure to show.
If you look at the attached spreadsheet - hopefully it will work - it shows what I mean. I am having trouble with 'Test'. The total should be 2 because that is what is in the pivot table on the left, but it is showing 'zero' (I would assume) because 'QUT' isn't showing.
Please could someone help? Hope this makes sense! I know what I am wanting to see, but I am finding it hard to describe it!
Many thanks,
Bookmarks