Skip to Content
0
Former Member
Sep 28, 2013 at 12:32 AM

Modelling at report level

24 Views

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.