help with pivot table formula, please

[adriand]

in a table i have a field wich contains forecast expenses and a field with effected expenses. i want to show, in a column, a year to date value (a cumulated value at time) for each of expenses for comparison.
inserting formula from pivot table bar didn't work, i tried SUMIF('forecast expenses'; ">0"; 'effected expenses').

can you help me, please?

[olasa]

Could you give an example of how it looks like/should look like?
Something like: http://www.excelforum.com/showthread...hreadid=368563

I can think of several different ways. The quickest way is to send a zip-file or a jpg picture. But explained in text down below is also ok.

Ola Sandström

[adriand]

hope this file have details enough to understand what i'm trying to do.
(for every new month filled for Effected Expenses, a cumulated formula for Forecast Expenses for the same period).