Best Way of getting a Column Total

[#1]

Hi there,

I am trying to get a column total for one of the columns in my table and using it to divide each entry on that same column to build another column.

I have already used the

"Column"/

Sum(Total "Column") and

"Column"/

Count(Total "Column") and

they both not giving me the right answer.

Regards,

[sivarajs]

Create a variable to get total sum like vSum=sum(total fieldname)

Then in chart use column(1)/$(vSum),you will get each value get divided by total sum

[kamalqlik]

Hi,

I have updated the test application as you need.

PFA with this.

In case of any issue please let me know

Regards

Kamal Naithani

[#4]

Hi Gents,

Thanks for the responses but all your suggestions have not worked so far.

Basically I need to use the sum of Rows in one column as a denominator to another column.

The total that appears on top of the column when u check the option(Show partial sums). I need to use that number.

I hope you guys understand me.

Regards.

[neha_shirsath]

Hi zamanihh,

Can you please attach some test file.

Regards.

[kamalqlik]

I think the application I have attached is showing the same result.

Can you make a test data and what you want ,so that i can apply the logic with your data.

Regards

Kamal Naithani

[#7]

zamanihh, I think you want to write like this

Sum("Column")/Sum(Total "Column")

[jagan]

Hi,

Try like this, this should work

=Sum(FieldName)/Sum(TOTAL FieldName)

Hope this helps you.

Regards,

Jagan.