Is this Report Design Possible?

Post Author: Allan

CA Forum: WebIntelligence Reporting

Was just wondering if the following report could be created in WI.

-

Year | Week | Sum(Sales) [for current year] | Sum(Sales) [for prev year] |

-

There is a sales fact table with a time_key and the sales value per day. This time_key maps to a column in the time dimension table.

The problem is, How would we get the aggregated values of sales for the prev year and the current year in a single grid?