This content has been marked as final. Show 2 replies
I tried adding a dropdown filter to my worksheet, however it only seems to show data from the top most selected item, even if all are selected. I have an example screenshot below:
In my 'item' filter, I have all 10 items selected. However, the Sum of EqVol is only showing the total from Item 1. If I deselect 1, it shows just item 2, and so on.
Do you know what I'm doing wrong? In theory, when I filter to 'All', it should look the same as if I don't have a filter at all:
Any insight appreciated!