3 Replies Latest reply on Jan 19, 2019 5:45 AM by Cristian Saavedra

    drill down and up issue - totals are wrong

    Patrick Weber

      Hi Tableau geeks, I have an issue when I drill up my calculations. At the lowest level "C Nr" the total sum is correct.

      The hierarchy is:

      Mitarbeiter->Renr->Bestellgruppe->C Nr

       

      19-01-_2019_11-34-11.png

       

      But when I collapse it to the higher level "Bestellgruppe" suddenly the totals are getting wrong even for each row.

       

      19-01-_2019_11-37-51.png

       

       

      These are my formulars.

       

      field Berechnung4:

       

       

      if sum([I Id Best])=206 // condition if Bestellgruppe is "supplies"

      then sum([stored_value])   //stored value is a database field

      else  (new calculation)

      end

       

       

       

      new calculation:

      (sum([sales]) - sum([purchase]) + sum([customer_shipping]) - sum([company_shipping]))*0,085  //all fields are in the database.

       

      I can't give you a work book because I'm not able to recontruct the different joins of the company live system.

      Is this possible that it happens because of a lot joins or is this a hierarchy issue?

       

      Thanks for any information.