Modelling at report level

[Former Member]

Hello, I have a question. I am loading some item level data but also looking into a header level table and doing a look up to populate one keyfigure in my item level table.  Now, the problem arises when user DOES NOT drag ITEM NUMBER in the report. what happens is that the keyfigure get summarized.  There is one keyfigure in this report which user does not want to see the item level data for and then there is this one.  For example:

This is what my data looks like in my DSO:

Sales Document     Sales Item     KF1(HDR)          KF2

101                              1                $50               $100

101                              2                $50               $150

so, when a user executes a report, if they bring in the item level data then they will have to add KF2 manually and if they take out Sales Item field then they will get the follwoing:

Sales Document         KF1(HDR)          KF2

101                              $100               $250

so in this case KF2 is right but KF1 is wrong it should be $50. 

If user brings out the sales item like mentioned before then, KF1 will be correct but KF2 will need to be added up.

I need to some how find a way where I can make the KF1 as stating once per Sales Document since document level will always have the single value.

Please help me if you can.

Thanks.

[anshu_lilhori · Accepted solution]

Hi,

You just need to apply exception aggregation on KF1--Make a new formula --Put your kf1 inside it--Hit the aggregation tab--Exception aggregation as first value--Reference characteristic as ---sales item.

Hope this helps.

Regards,

AL

[former_member182470]

Hi venkat,

Your requirement can be easily achieved by exception aggregation concept. You have already got answers. Below doc is the comprehensive doc on the concept.

http://scn.sap.com/docs/DOC-11217

Regards,

Suman

[MGrob]

HI

Just take KF1 and set exception aggregation to LAST with reference characteristic "sales item" This should solve it.

Martin