Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
i have attached sample qvw.
i have done a pivot table (please click clear button in the qvw to view the table). in that i have different branches. i need to rank the branches on three categories separately and then total of these three ranks gives total points.
finally, i have to rank for this total points.
when considering monthly selection, it works fine.
but when a quarter is selected, the total points are not changing.
eventhough a quarter is selected, it gives monthly total points.
My requirement is to get branch's total points alone for quarter.
how can i do this.
pls help me.
It´s changing here
If you need to make a Quarter Ranking
change all MonthStart for QuarterStart into your expressions
num(rank(
Alt( aggr(
(Sum({<DEC_MonthYear =,DEC_Date= {">=$(=date(MonthStart(vMaxSalesDate)))<=$(=date(vMaxSalesDate))"}>}SPAMT)
/
Sum({<DEC_MonthYear =,DEC_Date= {">=$(=date(MonthStart(vMaxSalesDate)))<=$(=date(vMaxSalesDate))"}>}MGN_CUR_TGT))
,BRCODE)
,0)))
it is changing when we select quarter. but that is value of monthly points.
for ex. if we select Q3, it gives september points & when we select Q4, it gives december points which is not correct.
my requirement is to get monthly total points. i.e., total points for oct, total points for nov,total points for dec.
then add up these three for Q4 points & then i have to do ranking for Q4 points
pls help me to do this.
If you need to make a Quarter Ranking
change all MonthStart for QuarterStart into your expressions
num(rank(
Alt( aggr(
(Sum({<DEC_MonthYear =,DEC_Date= {">=$(=date(MonthStart(vMaxSalesDate)))<=$(=date(vMaxSalesDate))"}>}SPAMT)
/
Sum({<DEC_MonthYear =,DEC_Date= {">=$(=date(MonthStart(vMaxSalesDate)))<=$(=date(vMaxSalesDate))"}>}MGN_CUR_TGT))
,BRCODE)
,0)))
No Anjos.
that is not the requirement.
i shouldnt change to Quarterstart. it should be monthly values.
i should get total points alone for quarter.
No Anjos.
that is not the requirement.
i shouldnt change to Quarterstart. it should be monthly values.
i should get total points alone for quarter.
Pls somebody give suggestions