5 Replies Latest reply on Jul 4, 2018 5:34 AM by Tushar More

    Sum (Entities) & Drill Down

    Mohammed Parvez

      Dear Tableau Experts,

       

      I am new to this forum, not aware of the rules. Still writing this query. I hope you guys will assist me.

       

      Data

       

      Table - A

       

      S. No
      Entity
      Issues
      1AEmail Server Not Working
      2BPhone Not Working
      3CEmail Server Not Working
      4DEmails Server Not Working
      5EMiscellaneous
      6FMiscellaneous

       

      Total Entities = 6 with different names.

       

      Table- B

      Issues
      Email Server Not working
      Phone Not Working
      Miscellaneous

       

       

      Requirement

      Team i would need to sum S.no = 6 distinct value.from Table-A   (S.no = 6)

      Later i would be creating an action on Table-B, so when ever i select Email Server not working issue, my S.no should change to 3 as i have same issue with three entities.

       

       

      S.no

      3

       

      Issues

      Email Server not working.

       

       

      S.no

      2

       

      Issues

      Miscelleanous

       

       

       

      Could you please assist me with the formulas.

       

       

      Thanks

      Parvez