Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
saggroad
Partner - Contributor
Partner - Contributor

AGGR with additional dimension

Hi

In the below aggregation which works well  I also want to add only 'NEW' products (TYPE = "NEW').

Could someone tell me how would I include also TYPE = 'NEW' in the below aggregation so that it only sums up 'NEW'

 

=-

sum(aggr(distinct only(INFPERIOD)='$(vInforceMonth0)',Value))

Thank you!

0 Replies