2 Replies Latest reply on Mar 14, 2017 11:08 AM by Andrew D'Agostino

    Drop down filter isn't working correctly

    Andrew D'Agostino

      Hi --

       

      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!

       

      Thanks,

      Andrew