7 Replies Latest reply: Oct 19, 2016 12:50 PM by Sunny Talwar RSS

    Exclude the Filter

    Subash Raj

      Hi,

       

      I have two filters category and subcategory. When i select from category it will affect to the charts if select subcategory it never affect the charts. i need to use for the below expressions.

       

      Chart 1  Expression :

      sum((aggr(sum(spendUSD) / aggr(nodistinct sum(spendUSD),CATEGORY) * speedToSavings,

      CATEGORY, SUBCATEGORY))

       

      Chart 2 Expression :

       

      lever

       

      Thanks in advance.

       

      Regards,

      Subash.