How do I add a Total Budget column while having monthly Revenue Columns?

[#1]

I have Product and MonthYear as Dimensions and Sum of Actual Revenue as an expression.

My Pivot Table shows the MonthYear along the top with a value for each product.

If I add a Budget Figure I get the Budget for each month but I only want the Total Budget to appear

What I want is:

Product     Jan Revenue     Feb Revenue...etc  ........Total Revenue     Total Budget

At the moment if I add the Budget to the expression I get:

Product     Jan Revenue     Jan Budget     Feb Revenue     Feb Budget etc.....     Total Revenue     Total Budget

Any ideas anyone?

[Gysbert_Wassenaar]

If the Revenue is actually 0 then yes it will be shown. But if there is no data, like for product D in June 2012, then it won't be shown.

[#3]

Hi Gysbert

Thanks for your help on this but I don't think I can work it this way.

I suppose another alternative is to set each individual column up using set analysis. i.e. 1st Column = Jan Actual, 2nd Column = Feb Actual etc....... then Total Actual and finally Total Budget

It loses flexibility but I guess it should work. What's your view?

[Clever_Anjos]

Try

if(ColumnNo()=0,sum(Budget), sum(Revenue))

as your expression

[#5]

Hi

Not sure I've got that one working right - can you please show me how you are thinking of using it in the above Sample Date.qvw

[#6]

Hi

Not sure I've got that one working right - can you please show me how you are thinking of using it in the above Sample Date.qvw