7 Replies Latest reply on May 17, 2018 6:40 PM by Jennifer VonHagel

    Repeated Items in Categories LOD

    Nitin Paighowal

      Hello,

       

      I am trying to implement below logic in Tableau:

       

      if  (subcategory = xyz  and  productname =aa) then count rest of the rows in the group (supercategory, category, sub category)

      else if (subcategory = xyz  and  productname <> aa) then dont count anything

      else if (subcategory = xyz  and  productname = aa ) but other product names are also aa then dont count that rows but count the rest

       

       

      Output should be :