7 Replies Latest reply: Oct 3, 2017 9:01 AM by Adwitiya Borah RSS

    Using set analysis/filters for dimensions

    Adwitiya Borah

      I have this table:

      Col1    Col2

      A            12

      B            9

      C            2

      D            5

      E            6

      F            10

      I'm building a bar chart and I need Col1 as the dimension. But I need only values B, C, E, F (say).

      How do we use set analysis or filters here?

      If we're using filters, the user should not have the freedom to manipulate this selection. At the same time, I need all the values available for other graphs in the sheet.

       

      Thanks in advance!