Calculating and Storing total for a Column

[sagar_vij99]

Hi All,

I am trying to calculate %share for an individual from same column, so Column NPT has no. of production hours. When i calculate % for A it will be sum(NPT)/sum(NPT). now the problem is it always show 100% whenever i select a person's name in filter and i understand the reason that it filters out other values as well. Is it possible to store total of NPT column separate and then i can use it to calculate percentage share of each individual..? Any help/suggestion will be appreciated.

eg,

Name,NPT

A,2

B,2

ideally share should be 50% for both but i am getting 100.

Thanks

Sagar

[vvvvvvizard]

Try sum(NPT)/sum(Total NPT)

[sunny_talwar]

May be like this

If you are in a chart and you want to ignore all your selections

Sum(NPT)/Sum(TOTAL {1} NPT)

or if you are in a chart and you want to ignore selection in just Name field

Sum(NPT)/Sum(TOTAL {<Name>} NPT)

[sagar_vij99 · Accepted solution]

Worked great. This is what I was looking..

Thanks..!!

[jmvilaplanap]

Hi sagar.vij99

You must to mark the response of stalwar1 as correct. Then people will could check this solution if they have the same (or similar) problem.

Regards