10 Replies Latest reply: Aug 23, 2017 7:03 AM by Sunny Talwar

# how to divide the individual column value by its total column value??

I need to calculate the values for the column named %.

I need the values corresponding to each date values.

Eg. 10/400 for offshore and 5/10 for onsite and so on..corresponding to all the date value.

I m  getting the valid data as per my logic.

Kindly guide me.

• ###### Re: how to divide the individual column value by its total column value??

Try this

I am guessing this is a pivot table with OFFSHORE and ONSITE is part of a dimension which is pivoted...

• ###### Re: how to divide the individual column value by its total column value??

Thanks Sunny!

But m not getting right data corresponding to the onsite as well as slight difference in offshore as well.

• ###### Re: how to divide the individual column value by its total column value??

Would you be able to share a sample to show the issue?

• ###### Re: how to divide the individual column value by its total column value??

i m afraid its confidential.

the issue is just in the values. and the sample is just like i shared.

• ###### Re: how to divide the individual column value by its total column value??

I am afraid I don't understand what is not working . May be someone else can help

• ###### Re: how to divide the individual column value by its total column value??

Thanks alot...it worked!

• ###### Re: how to divide the individual column value by its total column value??

Have you tried at least? Because, It's looks like you may not understand the expression.