6 Replies Latest reply on Dec 16, 2014 6:32 AM by Łukasz Majewski

    Two levels of Filter Actions - deselect/show all does not work

    Łukasz Majewski

      Hi,

       

      I cannot get the actions working properly in the attached workbook. What I would like to achieve is filter two bottom sheets (Distribution & Rolling AVG) by selecting relevant sections of upper sheets (Return & Replenishment). Also I would like Country filtered only if a specific one is selected. Therefore I created two sets of actions for each source sheet (From/To Region or Country). They are set to filter on Flow and Month(Order Date) too but the Distribution Sheet shows nothing when deselected (I know the rolling avg uses table calcs and hence its filtering requires amendments). How do I make it filter and unfilter the bottom sheet properly?