Count Number of Invoices

[Former Member]

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

[Former Member · Accepted solution]

Hi Sujatha,

Have a look at the How to guide 'How to... Count the occurrences of a characteristic' you can find it in:

https://websmp201.sap-ag.de/bw

SAP BIW -> Media Library -> How to ... guides -> Guide list SAP BW 2.x

This how to guide explains ow to deal with counting issues.

Hope it helps,

Andreu

[Former Member]

Thanks..It definitely is of help

[former_member374]

Hi Sujatha,

You are thanking a poster for his answer.

Please next time also give him points.

See: /people/mark.finnern/blog/2004/08/10/spread-the-love

This time I did it for you.

Remember: When you ask a question you also assume the responsibility to assign points.

Please check your other questions and if the answers were good. Spread the love and give some points.

Thanks in advance, Mark.