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