2 Replies Latest reply on Mar 26, 2020 1:25 AM by Chaitanya Kulkarni

    How to calculate Sum of Sales while using full outer join

    Chaitanya Kulkarni

      Hi Tableau Community,

       

      I'm trying to calculate sum of sales at category level, while I have sub-category being compared against other sub-category for the same category.

       

      So basically performing a full outer join.

       

       

      I want to fix the sum of sales at category level while excluding the sub-category2 here.

       

      Attached is the sample workbook. which also contains the answer i'm looking for when I don't have sub-cat 2.

       

      BR,

      CK