I need to transfer data fra a Navision database to a pivot in Excel by MS Query, but have the following problem:
I would like to see the total amount of money generatet by customers as well as the number of customers behind the figures, but in stead of the latter I get the total number of invoice lines. I have filled in the Group-by box in MS query and I thought that should do it, but it does not.
I thank you in advance for any help you can give, since the problem is driving me crazy.