1 Reply Latest reply on May 2, 2018 10:29 AM by Patrick A Van Der Hyde

    SUM of invoice amounts from 4 diff data sources

    Ruben Arias

      Hello Tableau'ers!!!

       

      I did some research and I cant find the answer to this question.

       

      I have 4 data sources all with an 'invoiceamt' sum(this field is available for all datasources) for each view.  I simply want to create a final view to add to my dashboard with a TOTAL SUM.

       

      I went ahead and created this calculated field and placed it in a new view but I am not returning an amount.

       

      Please advise...thanks!!!

       

      PBS, PLS, PSS, CLI are the diff datasource DB's, etc

       

      SUM([PBS].[Invoicedamt])+SUM([PLS].[Invoicedamt])+SUM([PSS].[Invoicedamt])+SUM([CLI].[Invoicedamt])