Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts
I have an expression for MTD sales
Sum({< MonthYear=, Date = {'>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'} >} Sales)
and I want to choose top 5 customers for each branch
SUM({<Customer = {"=Rank(SUM(Sales),4)<=5"}>}Sales)
How can i combine these two expressions together
Please Help
Can you paste your output here which you needed?
HI Kush
Here is the QVW attached
Expected each Branch by customer top 5 sales
HI this is the expected output
Expected each Branch by customer top 5 sales
see the attached