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.