3 Replies Latest reply on Nov 27, 2016 6:07 PM by Nachiket Dekhane

    Hi This is Preeti Dhanerwal

    Preeti Dhanerwal

      I am facing an problem in calculating the result for KPI values. I am using this formula





      But getting an error for not mixing aggregate and non aggregate function.


      Can anyone please tell me an alternative to run this .


      Attach is the sample data.


      Please see the result1 formula. I am also attaching the excel version which should be duplicated into Tableau. Data should be match in both Excel Pivot and Tableau (unfortunately not)


      Please help its really urgent.