Using calculated fields in a pivot instead of changing the raw data first?

Hi all,

I created a nice excel file with some cohort analysis regarding the number of months customers of different cohorts stay with a company. Basically I do a little manipulation on the raw sign-up data sheet and then run a pivot on it.
I want to see the cohorts in two ways:
1. number of customers.
2. $ from customers.

I have the first 1 and I want to get the second one without going through the same procedure again (i.e. manipulating the raw data). In order to get the $ terms, all I need is to multiply a $ column in each row in the columns that indicate the number of months that passed since a customer joined (see the attached example file please). When I try to do it with calculated fields in the pivot table, Excel multiplies the total number of customers with total $ from them all put together, which is of course wrong.

Any way to achieve what I want without having to created another data sheet just for $ terms?

I believe the attached excel better explains and shows what I'm trying to achieve. Would be awesome if you could take a look. Thanks!

dummy_for_cohort.xlsx

Hi,
That's not what I was looking for... as I wrote it multiplies the sum of $ by the total # of customers.
The 1st row should be $720, not 3600.
Thanks for answering though! Hope I'm clearer now.

looks good! thank you!! can you please show me the steps?