3 Replies Latest reply on Jun 18, 2018 8:37 AM by Jeffrey Lynch

    Top 3 across multiple dimensions

    Jeffrey Lynch

      I am stuck on a request that may not be possible but I have to ask.

       

      I have a very simple data set but a complex view I am being asked to create.  The business wants to see The Top 3 Product Categories and then the Top 3 Functional areas for the top 3 product categories and then the Top 3 sub functional areas of the top 3 functional areas  for the top 3 product categories.

       

      So in other words:

       

      Product:

      Shoes

                     Running   Green

                                      Blue

                                       Red  

                     Tennis       Blue

                                       Red

                                       Purple

                      Dress       Red

                                      Brown

                                      Purple     

      Pants

                     Dress       Green

                                      Blue

                                       Red 

                     Denim      Green

                                      Blue

                                       Red 

                     Running  Green

                                      Blue

                                       Red 

       

      Shirts

                     T-Shirt     Green

                                     Blue

                                     Red 

       

                      Dress      Green

                                      Blue

                                       Red 

                      Long Sleeve    Green

                                              Blue

                                              Red 

      Any help is greatly appreciated.

      Thanks,

      Jeff