calculated dimension problem

[sayanpwc]

Hello Team,

Facing a problem. pls help.

Find below the scenario.

I have used calculated dimension for this below scenarion :

=if(CONCLUSION='Paper Zambia','Paper',

if(CONCLUSION='Paper Malawi','Paper',

if(CONCLUSION='Paper Hunyani','Paper',CONCLUSION))).

Now the % HELD field value is getting summed up for its individual values but i want this value for this field only to be expression total or avg. not summed up. So the value against Paper should be around 80% or so like that. How can I achieve that?

Pls help!!!!

[pipuindia99]

[pipuindia99]

Please see the screenshot which i have given. this could help you

in Expression put Avg(%Held)

[sayanpwc]

Hi Prabhu,

Thanks for your note. But now I want it for enterprise field not avg for all the dimension.

i.e for paper the enterprise value i want is sum(enterprise)/2 where as for rest of the dimension i want sum(enterprise).

How can I do that?

Pls help.