9 Replies Latest reply on Oct 19, 2016 6:17 AM by sayali dengale

    Need help in getting the right data in visualization.

    Maheshh C K

      Dear Team,

       

      I tried to generate the profit (which should be calculated only from the Net Profit) for various event types but ended up with a visualization which is not correct.

       

      Input Data:

      Event

      Event Category

      Event Type

      Net Profit

      Profit Category Based

      1

      A

      Type1

      1000

      1000

      2

      B

      Type1

      2000

      2000

      3

      C

      Type2

      3000

      3000

      4

      A

      Type1

      4000

      1000

      4

      B

      Type1

      4000

      3000

      5

      C

      Type2

      5000

      5000

       

      Logic for Net profit

      Net Profit: Sum (Profit Category Based for that Type)

      Ex: Event – 4 has 3000 for Category B & 1000 for Category A which is summed up & shown as 4000 as Net profit for both the records.

       

      Expected Tableau Outcome:

      Type1 – Net Profit= 7000

      Type2 – Net Profit= 6000

       

      Current Tableau Outcome:

      Type1 – Net Profit=11000 (where I would require some help)

      Type2 – Net Profit= 6000

       

      Kindly help me on the same.

       

      Attaching the .twbx for your reference.

       

      Thanks

      Maheshh