Do I need AGGR ? Or something else

[petermoyaert]

I created a table in which I Can see for each account manager its sales and numer of customers for a specific supplier.

I want to set off this number of customers against the total number of customers of each account manager.

However I do not succeed in adding the right formula to see the total number of customers of each account manager. It is Always reduced to the number of customers of the selected supplier.

Who can help ?

[YoussefBelloum · Accepted solution]

Hi,

have you tried Aggr ?

Aggr(sum(sales),AccountManager,Supplier)

[petermoyaert]

AGGR(count({<Jaar_Kalender={$(=Only(Jaar_Kalender))}, Omschrijving_Merk={'Duvo+'} >}distinct Nummer_Klant), Naam_Vertegenwoordiger, Naam_Leverancier)

and

count({<Jaar_Kalender={$(=Only(Jaar_Kalender))}, Omschrijving_Merk={'Duvo+'} >}distinct Nummer_Klant)

result both in the same result and that's the number of customers where the products of the selected suppliers are sold.

I need this information, but I also want to know the total numer of customers of the account manager, to see what"s the potential.

[YoussefBelloum]

Try to give just sample data with your QVW

[petermoyaert]

So in the last 2 columns I get the same result. However in the last column I want to know how many customers in total this account manager has in portfolio. In this case 75, so there are 20 customers in his portfolio that do not buy the products of the selected supplier.

[YoussefBelloum]

ok, i see, but i was talking about the send just a a couple of lines from the source file and the app !

[petermoyaert]

Don't know how to do that, but I just found out, based on your suggestion !

In the AGGR function I need to exclude the supplier. Than it works !

Thanks

[YoussefBelloum]

COOL !

next time try to upload your app+ sample data to the community that they can quickly help

you need to do this:

1:

2:

at the end, don't forget to always mark the helpful answers as helpful, and the correct answer as correct !

Good luck !