I have a pivot table and chart as attached. It has:
Rows = Sections
Colum’s = decks
Values = signal types
Currently it is displaying values for all systems. I want to be able to filter on specific systems which I can do by dragging the systems field into the filter. However my rows and columns realign to the data specific for that system as you would probably expect, except if possible id like to keep the full columns and rows data in my chart as its effectively the axis for my 3d chart and provides a good visual overview of the density of signals with respect to the overall landscape.
Is there anything I can do to make this so?
Bookmarks