1 Reply Latest reply on Oct 4, 2017 10:04 PM by Tushar More

    Adding calculated field values from two data sources

    Steve C

      Hi,

       

      I have two data sources for two different product categories A & B. I need to report "total" loss numbers combined from both sources against the months of the year.

       

      Product A & B has 8-9 loss reasons and I've already used a calculated field for getting the numbers for the required fields. For e,g,

       

      Product A :-

       

      Truck Loss : 2

      Ship Loss : 4

      Airfreight Loss : 4

       

      Total Loss : 10 and it's spread across the months as Jan : 2 Feb: 2 : Mar: 1  Apr: 1 etc

       

       

      Product B :-

       

      Truck Loss : 2

      Ship Loss : 4

      Airfreight Loss : 4

       

      Total Loss : 10 and it's spread across the months as Jan : 4 Feb: 3 : Mar: 4  Apr: 2 etc

       

      Target total loss calculation must report monthly total losses i.e. Jan : 6 Feb: 5, Mar: 5, Apr : 3 etc.

       

      I made a join of both the sources against date field and getting month wise loss numbers accurately in separate sheets at individual data sources. But when I am trying to use a calculated field to sum [ total loss + [Product B].total loss] then the AGG field is giving weird numbers which are no way near to total losses number of the reported months.

       

      I just need 2+4 for Jan which is possible in 2 seconds in excel, why tableau made it so complicated ?

       

      Experts any help ?

       

      Thanks

       

      Steve