cancel
Showing results for 
Search instead for 
Did you mean: 

Count Number of Invoices

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks..It definitely is of help

former_member374
Active Contributor
0 Kudos

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.