2 Replies Latest reply on May 18, 2015 11:29 PM by Krishna Pai

    Is there a way to apply different filters to measures in neighboring columns?

    Krishna Pai

      Hi All,

       

      Is there a way to apply different filters to measures in neighboring columns?

       

      Please find attached the sample “Independent Filters” workbook.

       

      Here, I have Product Category as my dimension (col 1) and Sales as my measure (col 2). From Col 3 is where I need help.

      1.How can I get just one year’s revenue, in this case 2013 sales in Col 3 marked Sales (2013 only)?

      2.How can I get Sales for just one supplier “Acco” in Col 4 marked Sales (Supplier “Acco”)?

      3.How can I get Sales for just one department “Technology” in Col 5 marked Sales (Department “Technology”)?

       

      The issue is get all this info in a single table.

      Any help is appreciated.

       

      Many thanks in advance.