Spread yearly expenses over months in pivot table

[Star_tune]

Hi everyone,

I'm struggling with a problem for quite some time now and haven't found a good solution for it yet. Already checked a lot of excel tutorials.

I've made an excel workbook for all my expenses (and incomes) and made a pivot table to have a nice overview per month. But sometimes I have to pay - for example - my insurance for a whole year in once. Now I want it to show in the pivot table as a monthly expense spread over all months equally without having to manually divide my source data into 12 different rows each containing 1/12 of the total cost and all linked to another month.
I would like to say to the pivot table like: IF month = empty, than divide costs by 12 and link to every month... or something like this.

Anyone an idea who to solve this?

Thanks in advance!

 

[steve the fish]

Hi. I believe you would have to do it within your data before passing it to the pivot.