Alternate States combining rows

[#1]

Hi,

I have three states in my app.

Default, alt, alt2.

default is this years revenue

alt is last last years revenue

and alt is last years revenue

I need to combine all three rows to say the this years date so all rows with their revenue to one row for 21/12/2015.

Please can anyone help?

[Anonymous]

Using Set Analysis you evaluate for each specific Alternate State, maybe something like this :

     sum( {$} Sales ) + sum( {alt} Sales ) + sum( {alt2} Sales )

[#3]

thanks for your response.

where would you put that? I want each state to have its own column but combine a row, so get rid of the zeros