4 Replies Latest reply on Sep 5, 2018 7:51 AM by Ankit Bansal

    Aggregation error

    Sonali chavan

      Hi Guys,

       

      I have 3 fields,

      1. CY YTD which boolean filter, and gives me year till date value.

      2. I have one calculate filed sum(value1)/sum(value2)   ----->filed2

      3. i am creating on dynamic field which will calculate values on parameter selection like, YTD, QTD etc.

          IF [KPI]='YTD view' and [CY YTD] then ( [filed2])  end

       

      thing is that tableau giving me error cannot mix aggregate and non aggregate .

       

      converting ATTR(CY YTD) wont help. its giving me blank.

      SOmeone please suggest.

       

      Regards,

      Sonali.