How to Get Monthwise Orders

[#1]

I have enclosed file showing monthwise/datewise order received from customers.

Need below tables. Kindly help me to get the same.

Thanks in advance.

Customer Name	January	February	March	April	May	June	July	Grand Total
ABC	-	2641.00	492.27	706.78	-	-	-	3840.05
DEF	-	-	1283.80	829.60	4542.50	1271.00	3091.70	11018.60
GHI	1592.36	2564.80	2250.44	1448.50	1284.50	2110.22	3901.96	15152.78
XYZ	967.95	2581.97	-	386.41	-	9120.24	-	13056.57
Grand TOTAL	2560.31	7787.77	4026.51	3371.29	5827.00	12501.46	6993.66	43068.00

[#2 · Accepted solution]

Hi,

see the attached qvw

hope this helps

Regards!

[#3]

Thanks.... for helping me. Is it possible to do the same without using PIVOT table?

[#4]

everything looks fine. But is it possible to sort this table by total vaule?

[its_anandrjs]

Hi Mrkachhia,

Yes it is possible put following code sum(Total) in Sort-> Expression paste there sum(Total) select Acending or Descending order.

Regards,

Anand

[#6]

I have tried but not able to add sum(total) in sort. Can you show me by using the above example? Thanks

[#7]

OK.. I have sorted out this problem. Thanks for your help.

[its_anandrjs]

Hi Mrkachhia,

Oh its late response to you. See the attached file it is your solution, see expression window.

Regards,

Anand