Thank you for for help on this a few weeks back, it worked very well indeed!
I am now struggling with a little expansion on the above: Customers can be intercompany or not. I have separate field identifying this on each sales row. Also the internal customers are spread over the different continents (also a separate field stating which). And I would like the internal customers grouped per continent, while the external should be per customer name like before.So, like this is what I am trying to produce:
Internal customers Europe
Internal customers North America
Internal customers Asia
SUBTOTAL INTERNAL CUSTOMERS
External Customer 1
External Customer 2
External Customer 10
SUBTOTAL External customers TOP 10
ALL OTHER EXTERNAL CUSTOMERS
TOTAL EXTERNAL CUSTOMERS
Any chance of helping me on this one pretty please?
See .jpg file for what the table looks like in Excel... and I would like to have in QV :-)
This is an example of the data table. There are roughly 2000 lines in a normal week. Normally 150 external customers and maybe 20 intercompany ones.
As mentioned I would like to show intercompany sales grouped into the continents where they belong, while external customers should be by customer name.
Also notice that the rank has to be dynamic for external customers as intercompany customers (count of these) will vary for different time periods, so rank to get top 10 (or top 20 as shown in image included) will have to be done for external customer sales only.
Any help very much appreciated Lakhina, and thank you so much in advance for replying and looking at this.