2 Replies Latest reply: Sep 21, 2015 11:19 AM by Linda Diodato RSS

    Aggr using excluded fields



      I have the following expression, which is working fine.


      avg(aggr(sum({<Quarter= {$(=Max(Quarter)), $(=Max(Quarter)-1), $(=Max(Quarter)-2), $(=Max(Quarter)-3)}>}Sales), Product, Quarter, Customers))


      However, I need to build a second one, which still gives me the results aggregated by Product, Quarter and Customersbut I must ignore whatever selection is active in Customers so that I can compare the two sets of results, one related to a specific Customer and one related to the overall average Sales amongst them.

      I've tried all the set analysis I could think of but I did't manage to get it to work - when I select values in Customers, the selection applies to the second expression no matter what.

      Can somebody please help?

      Thank you!