Pivot with Top 10 customers AND...

[#1]

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

[#2]

Hi Tor,

Could you post the Excel so i can import it into QV and work off it?

Regards

Rahul

[#3]

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

[#4]

Hi Tor,

Please find attached a solution for your problem.

Best of luck! and have a great weekend

Regards

Rahul Lakhina

[#5]

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

[#6]

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

[#7]

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>

[#8]

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

[#9]

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 ?

[#10]

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 ?

[#11]

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 ?