top 20 sales

[#1]

HI Experts

I Have a sales Qvw, in that, I have to calculate the Sales for Current Month & previous Months

Here with this I attached the Sample Qvw

i have done a ranking in extraction on the basis of customer by branch. (top 200 customer sales by branch)

(the script for ranking is commented on extraction tab for reference)

i need to calculate current month sales/workingdays and same for prev month.

with this ranking, i made a table but i m getting same sales value for current month and prev month which is not correct.

pls help me to calculate this.

Also, there is an expression called difference which is curr month sales - prev month sales.

i have to do a subtotal on this difference value for only top 20(top 20 negative) customers in each branch.

Please Suggest Me how to calculate

[satishkurra]

Please find attached the QVW file for reference