aggr() function with selected dates

[#1]

I have apivot table with the following dimension,

=if(vselect='sector' and (cdate >= vStartdate AND cdate <= vEnddate) , aggr(if(rank(count(sector))<=50,sector),sector))

but i am not getting the result for the range of dates chosen,

instead, it just aggregates the data for the maximum value of the date chosen, ie vEnddate

Please help me out. I cant figure out the issue.

[#2]

try this

=if(vselect='sector' and cdate >= vStartdate AND cdate <= vEnddate , aggr(if(rank(count(sector))<=50,sector),sector))

[er_mohit]

Try this in dimension side

aggr(if(rank(TOTAL count(sector))<=50,sector),sector)

OR TRY THIS

aggr(if(rank(TOTAL count(sector))<=50 AND vselect='sector' and cdate >= vStartdate AND cdate <= vEnddate

,sector),sector)