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?