Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to show the sales revenue of the top ten customers (ranked by revenue). I have solved this.
Also I would like a subtotal of these, and on the next row, the subtotal of all the other customers (number 11 and up).
At bottom I would like a grand total for all customers, (number 1 and all).
So..
Customer 1
Customer 2
.
.
Customer 10
SUBTOTAL TOP 10
ALL OTHER CUSTOMERS
Grand TOTAL
Can anyone please help?
Thanks!
NorTor
Norway
Hi Tor,
Could you post the Excel so i can import it into QV and work off it?
Regards
Rahul
Dear Lakhina,
please find the xls file. Notice that this one only has a few customers. Normally there will be like 150-200 external clients and 10-30 intercompany ones on a monthly reporting basis.
Thank you again!
Have a nice weekend very soon!
Tor Olav
Hi Tor,
Please find attached a solution for your problem.
Best of luck! and have a great weekend
Regards
Rahul Lakhina
Dear Lakhina!!
I am most grateful for your effort and so quick in doing so! I will try this solution tonight on the full dataset, and based on your earlier solutions I am confident it will work as I hoped for!
Thanks and respect from me!
Tor Olav aka NorTor
Hey NorTor,
Thank you for the kind words!
While going through the file i found it was not working as per my designe and had a bug which i have taken care of in V2 attached.
Hopefully this will work exactly as you had hoped!
Regards
RL
You truly are incredibly nice!
I will test later today and report back.
Thank you Lakhina and enjoy the weekend!
Cheers
Tor Olav
lakhina007 <qliktech@sgaur.hosted.jivesoftware.com> skrev:
QlikCommunity<http://community.qlik.com/index.jspa>
Re: Pivot with Top 10 customers AND...
created by lakhina007<http://community.qlik.com/people/lakhina007> in New to QlikView - View the full discussion<http://community.qlik.com/message/249445#249445>
Dear Lakhina!
As expected from you: It worked perfectly! ...what a perfect start on the weekend!
Thank you thank you!
Hope you are enjoying the friday night!
Cheers from your #1 fan,
Tor Olav aka NorTor
Dear Lakhina,
The solution is great, it is working for me too.
By any chance, do you have any idea how the show Top 5 Customers and sorted by their Sales ?
Dear Lakhina,
The solution is great. It is working for me as well.
Btw, is there any chance that we can show the Top 5 Customers sorted by their Sales value ?
Dear Lakhina,
The solution is great. It is working for me as well.
Btw, is there any chance that we can show the Top 5 Customers sorted by their Sales value ?