Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try sum(NPT)/sum(Total NPT)
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)
Worked great. This is what I was looking..
Thanks..!!
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