1 Reply Latest reply on Jun 8, 2016 2:11 PM by Patrick A Van Der Hyde

    Need Help with Filters That Are Not Working As Designed

    Leo garcia

      I have a dashboard that is made up with about five other sheets.  One of the sheets shows our monthly sales which I have filtered to only show 2016 (I want our team to only see the current year for this part of the dashboard).  I have another sheet that graphs out our sales by product by week which has both 2015 and 2016 data.  When I drill down on Sales by Product the dashboard works like a champ.  It will display the weeks data in the Sales by Product section as well as shows which month that sales was for Monthly Sales section.  The problem is when you unselect the week the Monthly Sales section pulls in both the 2015 and 2016 data.  When I go back to my Monthly Sales sheet the filter has changed and now includes both 2015 and 2016.  How do I stop this from happening?

       

       

      Monthly Sales (original view)

      May     April     March     Feb     Jan

      ###     ###     ###          ###     ###

       

      After I unselect the week from the product dashboars

       

      December     November     October ...... Jan

      ####               ####          ####               ###

       

      I figured this out by using sets