7 Replies Latest reply: Feb 28, 2012 5:31 AM by Matthew Fryer RSS

    Bypass selection of Year ,Month in AGGR function with sum

      I want to bypass selection of Year , Month and Quarter but due to Aggr its not happening.

      I used this expression

       

      sum({< Month=, Quarter=, Year=,Status={'Active'}>}aggr(Amount,ContractNo))

       

      and also  aggr(sum({< Month=, Quarter=, Year=,Status={'Active'}>}Amount),ContractNo)

      but both are not working.

      I want that on selection of Year, month ,Quarter my data is not changed.

       

      Any ideas how I can tackle this issue.

      Thanks

      Vimlesh Gupta