One table, one pivot multiple selections

[NickvdB]

Hi,

I have one table with monthly figures. I would like to see in one pivot the figures for that, meaning selecting the data for period 4, but also in another column the year to date figures, which is done by selecting period 1 to 4. Can I have in one pivot a selection per column of data? So one column showing figures for period 4 and other for period 1 to 4? I don't like to work with two pivots next to eachother, because it will look messy when not all rows are the same.

Thanks

 

[Cubist]

There should bee an option for "Show as Running Total".