2 Replies Latest reply on Aug 7, 2014 6:26 AM by dave john

    cannot mix aggregate and non aggregate comparisons or results in if

    dave john

      hi, I'm facing this issue when I use case statement or if condition when i try to mention column in secondary data source.

      requirement is text table should be able to pivot based on dimension selection using parameter. I'm using a calculated field that captures dimension based on parameter selection.

       

      I'm getting this error  "cannot mix aggregate and non aggregate comparisons or results in if " when I try to reference a dimension from 2nd source..in calculated field..

      I can't mention  linked column in detail section because user should be able to pivot the table based on dimension selection..

      pls let me know if there is any workaround..thanks..