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.

       

      Req:

      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

       

      Issue:

      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!!

       

      Thanks,

      KK