4 Replies Latest reply on Nov 14, 2017 11:00 AM by Deepak Rai

    Avoid double count in Tableau

    Shri Siva

      I have 3 columns

       

      die_type

      item

      siteid

       

      In my graph for one die type  and one siteid  and one item Qty is 20k

      If the user select 2 die_types also for the same site id the qty should be 20k as per requirement.

      But the moment I select 2 die_types qty is double counted to 40k . Can someone let me know how this can be fixed.

       

      What I need is below

       

      die_type   SITE_ID          ITEM                QTY

      RT87Z     FG_SHIP       MAX1234            20000K

      RT88Z    FG_SHIP       MAX1234             20000K

       

      what Iam getting is below

       

      die_type   SITE_ID          ITEM                QTY

      RT87Z     FG_SHIP       MAX1234            20000K

      RT88Z    FG_SHIP       MAX1234             40000K

       

      If the user selects different site_id or different item QTY should change accordingly.

       

      below graph you can see that one die type should 20K

       

      but when 2 dietypes are selected qty actually doubles