Skip to Content
avatar image
Former Member

Issues on aggregation for drill down with pic

Hi ,

Do have any idea how to solve the issues for the aggregation

As we could see the SRM COntract Util was : 586,105.00

Now if we drill down till SRM Contract

It supposed to showed 586,105.00 . It cumulative.

Anything that I miss.. I did try to add additional ref Char for SMR as well, but its still not working.

Hope someone could e me some clue.

Rgds

Edi.

Drill Down 1.jpg (31.9 kB)
Drill Down 2.jpg (19.5 kB)
Drill Down 3.jpg (53.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 22, 2015 at 08:22 AM

    Hi Edi,

    i don't get it.. you are using SUM as you have two contracts assigned to your SRM contract, so i think you are getting correct result. If you want to see 586105 try with min/max or avg.

    BR,Todor

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 22, 2015 at 08:49 AM

    Hi Edi,

    From the first screen shot, I understood that you are calculating result as "average" for the keyfigure (total contract utilization)

    SRM contract has contract (might be a sub contract for example), where it has total , but when you take out the contract , SRM contract gets summarized.

    Instead you canĀ  hide the contract from query , you will get the desired output.

    Add comment
    10|10000 characters needed characters exceeded