2 Replies Latest reply on Nov 23, 2018 1:49 AM by carlos capella

    Filter a variable with indirect dimension

    carlos capella


      Please find the workbook attached.


      I'm trying to build a tool that compares projects with the same characteristics (or dimensions).


      The problem is that I want to filter the bar chart by:

      1) First, I want to be able to filter the bar chart by the usual quick filters (in this case, Type and Brand).

      2) But alternatively and at the same time, I want to select a project and automatically show ONLY those projects with the same Types and Brands as the selected project.


      In our example, I would be able to select Types and Brands and that would filter the bar chart. However, when I select Project 2, the bar chart will automatically be filtered by Type = 2 and 3, and Brand = 2 and 3 (you can see which Types and which Brands are included in each Project in the Project-Type and Project-Brand sheets).


      Do you have any idea how can I do this?


      Thank you in advance for your help!