Percentage of row total should display 100%

[Rajesh]

Hi All,

I am trying to achieve Percentage of row total  100% like below screen shot

in pivot table its showing like below screen shot

can any one suggest how can i achieve this.

Thanks

Rajesh

[effinty2112 · Accepted solution]

Hi Rajesh,

Use the TOTAL qualifier in your expression like this:

sum(TOTAL <dv_instance_question> Amount)

Good luck

Andrew

[Anonymous]

for detractor column try like this: num(sum( detractor) / (sum(detractor)+sum(active)+sum(passive)+sum(passive-NR)),'####%')

[sunny_talwar]

What is your expression right now?

[Rajesh]

Thanks Andrew,

its working now as expected.