Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Experts
In my Qvw I having Sales data for two Months April & May and 2 Branches
My requirement is to show top 10 With Max Sales For each branch
But if I select May my Condition Working, but Not working for April
Got Stuck With This, Please Help
HI Dass
Yes
In the Script there is the restriction
I guess I do not understand your issue, the only thing that I am seeing as not populating any info when you select on April is "Last Month Sales", in your description you mentioned a top 10 but I don't see any top 10 in your table or any of the objects, if you could be more clear into what is not working we might be able to provide better assistance. or is the issue at backend level ?
aggr(if(Rank(sum(sales)<=10,branch1),branch1
aggr(if(Rank(sum(sales)<=10,branch2),branch2