Skip to Content
0
Former Member
May 10, 2010 at 01:27 PM

No. of items if more than 25

29 Views

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