2 Replies Latest reply on Mar 30, 2018 10:15 AM by John Sobczak

    Filter Twice In Same Worksheet

    Armaan Kohli

      Hi All,

       

      I have this scenario in Superstore data where i want to use Sales, Profit and Categories in same worksheet.

       

      So the main thing in which i am facing problem is:

       

      1- I need to show Sales for all the categories (Technology, Furniture and Office Supplies) in the worksheet.

      2- I need to show Profit for only 'Furniture' and not for 'Technology and Office Supplies' in the same worksheet.

       

      So is there any way i can show both the scenario in the same worksheet together???

       

      Please Help!!!!

       

      Best Regards,

      Armaan Kohli