Skip to Content
0
Former Member
Aug 01, 2007 at 12:23 PM

Is this Report Design Possible?

11 Views

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?