aggr vs total

[#1]

Hi!

A have table (please see atachment) and expression:

=if(month = '201211',sum( TOTAL {<month={'201211','201210','201209'}>}Sale),0)

I have problem with my formula. When i select only one country it works, when several - i have total sum.

i trying use aggr function like this:

=if(month = '201211',aggr(sum( {<month={'201211','201210','201209'}>}Sale),Country),0)

but it it not working

i need sum 3 month sale by Country

Please help if you can

[perumal_41]

Hi,

I attached one application please find out

[#3]

Hi, Perumal!

Thank you for help.

In attachment sum is correct, but i need it apear with '201211'.

is it posseble?

[perumal_41 · Accepted solution]

Hi

Try this expression

Sum( {<month = {'201211'}>} aggr(NoDistinct sum( {<month={'201211','201210','201209'}>}Sale),Country))

[#5]

Thank you!!!

it works perfectly