Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
can any one help me in achieving this requirement.....the thing is i need to show sum of volume against recommended R_Calmonth column what i mean is
what i need to show for R_Calmonth 201707 =201704+201705+201706 which is 1600+1600+1768 =4968
for 201708=201704+201705+201706 +201707 which is 1600+1600+1768+400=5368
201709=201704+201705+201706 +201707+201708 which is 1600+1600+1768+400=5368(beacuse i dont have any volume for 201708)
Expression i tried is
Actual: Sum({<CALMONTH = {">=$(=YearStart(Max(CALMONTH))) <$(=max(CALMONTH))"}>} VOLUME)
but i am not getting expected output
Any suggestion plz
thanks
Naveen
Hi,
try this :
=aggr( rangesum(above( sum(CALMONTH), 1, rowno() )), VOLUME)
HI,
It is giving only aggr value....
Is this requirement is not possible to achieve ?
It is possible to achieve but scenario is not clear.
May be one of the experts can help you.