5 Replies Latest reply on Feb 25, 2013 11:18 AM by Ken Zheng

    Help to make calculation field with 2 worksheets datas

    PATRICK GELLENS

      Hello,

       

      I want to write a formula in a calculated field with datas coming from two different worksheet. Here is what I have.

      I got the message the calculation contains errors: "cannot mix aggregate and non-aggregate arguments to function.

      If you watch the sheet 6 and 7, I just want to have a percentage of those two datas.

      Thanks

       

      http://public.tableausoftware.com/views/COMPETITIVITELIGUESFRANCE2004-2012/Sheet7?:embed=y