Difference Total in Cross Tab

[#1]

We are having trouble getting the difference of two columns totals in a cross tab in Web Intelligence. We have a report based on an Excel spreadsheet which pulls in all of the data. There is a report filter that restricts the data to just two years. If the filter is on the block we are having the same issue.

The problem is that we want to see the difference in total sales revenue from one year to the next. I have defined the Sales Revenue Change variable as follows...

=Last([Sales revenue]) - First([Sales revenue])

That works fine for each State, but not the difference between the totals for 2006 and 2005 which should be $1,826,896.80.

Any suggestions on how to do this?

We are on 4.1 SP06 Patch 4.

Thanks,

Noel

[Former Member]

Hello Noel,

Could you please try Sum([2006 Sales Revenue])-Sum([2005 Sales Revenue])?

I tested this using excel and its working fine for me please see below screen shot.

Regards

Niraj