Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to show Pivot table expression total percentage in text object, but its showing 100% instead of 32%, plz suggest.
plz see below lmage
Thanks
Rajesh
Thank you Anjos,
its working now missed the brackets earlier
=Num(Count({<[NPS catagories] = {'Detractors'}>}[NPS catagories])/(Count([NPS catagories])),'#.#0%')
Which expression is [NPS Catagories]?
its Count(NPS Categories)/Count( Total NPS Categories) in pivot table
And you want to show only for Detractors?
Count({<[NPS Categories]={"Detractors"}>}[NPS Categories])/Count([NPS Categories])
yes Anjos,
but your expression is not working in text object
Whats the result?
showing Zero
May be this
Sum({<[NPS Categories]={"Detractors"}>} Aggr(Count([NPS Categories])/Count(TOTAL [NPS Categories]), Type, [NPS Categories]))
Or this
Sum({<[NPS Categories]={"Detractors"}>} Aggr(Count({<[NPS Categories]={"Detractors"}>}[NPS Categories])/Count(TOTAL [NPS Categories]), Type, [NPS Categories]))
Thank you Anjos,
its working now missed the brackets earlier
=Num(Count({<[NPS catagories] = {'Detractors'}>}[NPS catagories])/(Count([NPS catagories])),'#.#0%')