aggr function

[#1]

Hi.I faced a problem.

I have tw fields Subregion and Product. Expr  is

cout({$<CalendarYearQuarter={'2013-Q1'}>} distinct CustINN ) 

In total we see 3362. How to write expression which will calculate this total sum in front of every product.

What I would like to get is

This   expression   aggr( sum(Expr),Subregion  )   doesn`t work.

[#2]

cout({$<CalendarYearQuarter={'2013-Q1'}>} distinct CustINN ) 

[MK_QSL]

aggr(count({1}DISTINCT CustINN),Subregion)

[MK_QSL]

Full Total

count(TOTAL {<CalendarYearQuarter={'2013-Q1'}>} Distinct CustINN )

For SubRegion wise Total

count(TOTAL <Subregion>{<CalendarYearQuarter={'2013-Q1'}>} Distinct CustINN )

[#5]

Manish, you are geneus) It Works!  Thank you very much)

[MK_QSL]

Glad that my answer helps you.

Kindly close this thread by selecting correct/helpful answer so that others having the same problem can use this thread.

[#7]

Manish, one more question. I didn`t notice that the filter was on Subregion. So this expression

count(TOTAL <Subregion>{<CalendarYearQuarter={'2013-Q1'}>} Distinct CustINN )

calculate total amount, but how to aggregate it by Subregion? Thanks

[MK_QSL]

Full Total

count(TOTAL {<CalendarYearQuarter={'2013-Q1'}>} Distinct CustINN )

For SubRegion wise Total

count(TOTAL <Subregion>{<CalendarYearQuarter={'2013-Q1'}>} Distinct CustINN )

UPDATE: ONLY HELPFUL ANSWER?

Check enclosed file...