cancel
Showing results for 
Search instead for 
Did you mean: 

Issues on aggregation for drill down with pic

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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