This content has been marked as final. Show 2 replies
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.