Sunday 15 June 2014

excel - How to generate a column in pivot table -


I have a small challenge in Excel.

Let's say I have an impression and other column column called Clicks. I want to display click rate on a pivot table (the ratio between click rate click and impression is).

I have tried (almost) everything, and unfortunately I am not able to do this: (

 Enter image details here


As you can see from the image, I can manually calculate the click rate, though I I have failed to do this within the pivot table ...

 Enter image details here

 image here Enter a description

and how a calculation field is generated. Thanks for your helpful comment, JosieP.

No comments:

Post a Comment