Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try this expression
Sum( {<month = {'201211'}>} aggr(NoDistinct sum( {<month={'201211','201210','201209'}>}Sale),Country))
Hi,
I attached one application please find out
Hi, Perumal!
Thank you for help.
In attachment sum is correct, but i need it apear with '201211'.
is it posseble?
Hi
Try this expression
Sum( {<month = {'201211'}>} aggr(NoDistinct sum( {<month={'201211','201210','201209'}>}Sale),Country))
Thank you!!!
it works perfectly