Total percentage calculation

[#1]

Hi I am trying to calculate the total percentage in this qva, any help would be appreciated.

I have attached the file.

[CELAMBARASAN]

Use sum of rows option. by defaul it will be sum of expression.

[#3]

hi

ctheresa75

maybe you can help this to you

if(Dimensionality()=0,

sum(aggr([Monthly Goal]/sum(Total [Your Expression in Monthly Goal]),Dimensions)),

[Monthly Goal]/sum(Total [Your Expression in Monthly Goal]))

regard

GERNAN

[narender123]

HI

Select Chart Property->expression->Select Sum of rows button .

Try it.

Regards:

Narender

[#5]

Sum of option works for the other columns , see the total in the snap shot but not in the ‘Goal %”

[#6]

Thanks for getting back to this, well I try sum of row button, it gives the answer as 165% which Is wrong, supposed to be 20%.

[#7]

hi

ctheresa75

what is your expression in 'GOAL %' ?

please give to me

[#8]

hi

ctheresa75

i think like this ?

if(Dimensionality()=0,

sum(Total [Total Billed GP])/sum(Total [Your Expression in Monthly Goal]),

[Total Billed GP]/sum([Your Expression in Monthly Goal]))

regard

GERNAN

[preminqlik]

send your field name expression once ?...i mean GOAL % expression?

[#10]

Thanks I will try this and will respond.