5 Replies Latest reply on Dec 2, 2015 5:06 AM by Tableau kumar

    Dynamic Dimensions for the rows

    Amer Ghanem

      Hello,

       

      I have a list of products that have a product name, product subcategory, product category, manufacture. I have also three filters, Manufacture, Product Category, and Product Subcategory. I have a view with sales 2009, sales 2010, and sales 2011 in the columns, and I am trying to achieve dynamic row selection based on the filters. So when the user, selects a specific manufacture, I want to rows to be the product categories. and when the user selects a product category in the filter, I want the rows to display subcategories. and when the user selects a sub category, I want the rows to be the product names. I am trying to achieve this for a tabular view, and a chart where the coloring should be based on my criteria. So when the user selects a manufacture, the colors reflect product categories, and so on.

       

       

      I hope it is clear what I am trying to say.

       

      Thanks for the help