show only in total in pivot table (QV9)

[martijn]

Hi all,

I want to build a pivot table with the following layout:

	January	February	Etc..	Total
Costnumber	Revenue	Revenue		Revenue	Budget
100000	100	150	0	250	300
100050	150	50	0	200	150
Etc	Etc	Etc	Etc	Etc	Etc

I want to see the budget only in the last total column, not for each month. I've been searching the forum and QV for an answer, but I can't seem to find one. Does anyone no if this kind of table is possible?

Thanks for your reply

Regards,

Martijn

[martijn]

The problem with this solution is that every column has to have the same width. Which, for the columns per month, is too width. It is a solution, but is it the nicest?!

Martijn

[martijn]

I've done it the other way. I've greated 14 expressions with SetAnalysis. one for each month and than a total Revenue and Budget...