Hi experts,
We have the following scenario: We want a list of all vendors that have more than 25 invoices per year.
So the list should be designed like:
Vendor_______ No of invoices
Vendor A______ 243
Vendor B______ 97
Vendor C______ 151
...
We have an accounts payable info cube to use, including documents (invoices). I manage to get a report where I actually see the no. of invoices per vendor per year, using "calculating result" as no. of items, BUT not without listing all the documents.
How can this be achieved, i.e. like the above design (=not displaying the actual document numbers)?
BR,
Niclas