5 Replies Latest reply on Aug 31, 2018 12:37 PM by Graeme Elliott

    Dynamic Columns Based on Filter Value

    Graeme Elliott

      Hi all,


      I have another query which I hope someone can help with. It's an idea floating through my mind which I am having trouble getting the required result.


      I have attached my packaged worksheet. Here I have a table consisting of a few brands who are part of different industries. I am measuring some different data types such as Feedback and Messages received.


      In this table I have the data type on the left and the first calculated column is a sum of each data type for the brand selected (Brand 1 for instance). What I would like to do now is have a column next to this so I can compare dynamically how the related brand type (in this case, Aerodynamics) done on average during the filtered month.


      So the filters will be Brand 1 and Aerodynamics (they are related) and the table will look something like this:



      What would be the best way of going about this?


      Thanks in advance for the help!


      Message was edited by: Graeme Elliott Re-attached file.