Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Using Set Analysis you evaluate for each specific Alternate State, maybe something like this :
sum( {$} Sales ) + sum( {alt} Sales ) + sum( {alt2} Sales )
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