6 Replies Latest reply on Oct 20, 2017 7:18 AM by KK Edla

    Multi Level sorting for Mutilple dimensions in crosstab (Year split by Month)

    KK Edla

      I'm stuck with some weird requirement. I tried multiple ways and researched on the tableau community and on internet, but could find an answer.



      I need to find  Sales for Top 2 Regions and Top 2 Categories in each of those regions and Top 3 Subcategories for each Category by Calendar Year (broken by month). And ROW total for each subcategory



      In the attached workbook


      NoDate - Shows exactly what I need

      WithDate - This is the duplicate of NoDate workbook, but added Month(Order Date). -- This doesn't give me the correct results


      Can you please help me with this?


      Appreciate your time!!