Bex Report to calculate number of sold to party

[Former Member]

Hi Team,

I have requirement to create a report to count the number of sold to party having Net sales > 0 based on company code and market sector for a year.

Each record in the cube have this combination.

I can use the condition in the report for the key figure Net sales > 0. But how can calculate the number of sold to party for each combination of company code and Market Sector

Please let me know your thoughts.

Regards,

Ramesh

[pradeep_gupta]

HI,

To calculate count go through the doc.

https://websmp203.sap-ag.de/~sapdownload/011000358700002762432003E/HowToCount.pdf

http://scn.sap.com/thread/2076273

Pradeep.

[former_member182343]

Hi Ramesh,

1. Create a condition on key figure Net sales with expression less than ( < 0 ) and select select charectrstics specifically according to requirement . In your case it is market  Sector  & Company code.

2. Now get Count using exception aggregation - Count.

Create Formula/Selection and get the same.

- rvc

[Former Member]

Hi Vijay,

I have used the condition Net>0 and created a formula and chosen the exception aggregation as counter of all detailed values based on sold to party.

Challenge here is if I use the exception aggregation, then the net sale value > 0 condition is not getting applied in the counter.

If the condition NS>0 need to work along with the counter, I need to have sold to party in my drilldown. But  the requirement is not to include sold to party in the drilldown.

Do you have any view on how can we apply the condition to the report by including sold to party in the condition but without using the sold to party in drill down of the report.

Regards,

Ramesh

[anshu_lilhori]

Hi,

Check the below doc.It might be helpful in your case.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c09f49c2-7448-2c10-ac92-d75f263a0...

Regards,

AL