Hi,
I'm creating a pivot table, and I'd like it's structure to remain static, where only applicable items with no data are shown. Please see below and attached for an explanation of what I'm looking for.
I have 2 fields that I'm placing in the 'rows' area of the pivot table, Type (Column A) is 'Fruit' or 'Vegetable'. Name (Column B) is the Fruit or Vegetable name.
I have 2 customers, Customer 1 is buying all of the items under the Type 'Fruit' and 'Vegetable' (there are 3 items in each category), and Customer 2 is buying only 2 items in each category.
I would like to set up my pivot table to be set up in a way where all 3 items under Fruit and Vegetable are visible whether I filter on Customer 1 or 2. The only way I can think of doing this is by editing the field settings of the 'Name' field to show items with no data. But when I do this, it shows even the items categorised against 'Vegetable' in the fruits section and vice versa, like the attached image. The view I would like to achieve is essentially only items applicable to the fruit category appearing under fruit and only items applicable to vegetables appearing under the vegetable category, and that view remaining static. Does anyone know how I can achieve this? I've attached the file to this thread.
Capture.PNG
Bookmarks