6 Replies Latest reply on Feb 12, 2019 1:04 AM by Patrick Weber

    calculation and total in drill down wrong

    Patrick Weber

      Hi I have a problem in a drill down view in my example you'll see invoices, the problem is that information of company shipping is stored in the invoice table e.g. invoceID100 has total shipping cost= 11 USD,

      the information about delivery costs for the customers is stored in another table where you'll find each position of all invoices (the data structure can't be changed because it's always used in my company).

      My issue shipping and delivery cost only exist for each invoice in total.

      But if I drill down the view then tableau sums up every row for shipping and delivery.

      That's why the calculation calc is also wrong because delivery and shipping cost doesn't exist several times in an invoice.

       

      How to solve this problem?

      Thanks in advance.