Skip to Content
0
Former Member
Nov 09, 2004 at 08:44 AM

Count Number of Invoices

239 Views

Hi

Iam having a scenario where I need to count the total number of Invoices raised at calweek level for different outlets.

Say for example a salesman raises 2 invoices at an outlet A in a week and 5 for another outlet B in the same week.

Then the report will look like

Outlet No of bills raised

A 2

B 5

My cube has Outlet,Invoice number and 0calweek. I need to check the total number of Invoices / bills raised.

I think adding a counter in the cube will help. Is this correct way of doing?If so how do I populate the counter field?

I tried creating a structure in Bex..But without a keyfigure the structure and formula to count the rows in this structure doesn't work.

PLS HELP.

Thanks