Hi guys,
this is the dimension for two of my pivot table.
1) =if(vselect='sector' and (cdate >= vStartdate AND cdate <= vEnddate) , aggr(if(rank(count(sector))<=50,sector),sector))
2) =if(vselect='Channel' and (cdate >= vStartdate AND cdate <= vEnddate) ,channel)
both the pivot tables have similar expressions (6 of them)
(2) works fine. It displays the channel and aggregates the expressions for data betweeen vStartdate and vEnddate
But (1) is not showing data betweeen vStartdate and vEnddate. It only shows the data for the last date, ie vEnddate.
i cannot figure out why this expression is not functioning since the only difference is the aggr() and rank() functions.
Pls help me out.
With Regards,
Arjun