Hi,

My Automotive client has a requirement to create a sales analysis report that comprises the below columns:

1. Car Model
2. Current Month Sales
3. Previous Month Sales
4. Current Year Sales
5. Previous Year Sales

Report Requirement Description:

User would be selecting Date Prompt, as per the Date Prompt selection the report should display the output.

Work done:

My client has requested to avoid using Union Reports for this requirement. Hence I created a Dimensional Hierarchy on Calendar (Date) Dimension and created the following calculated measures in the Logical Fact Table in the RPD: Current Month Sales, Previous Month Sales, Current Year Sales, Previous Year Sales using the Time Series functions 'ToDate' & 'Ago'.

The Outcome:

When I pull EITHER Car Model with Current Month Sales & Previous Month Sales OR Car Model with Current Year Sales & Previous Year Sales columns into the report Reports are working as expected but whenever I pull Car Model, Current Month Sales, Previous Month Sales, Current Year Sales & Previous Year Sales columns all together -- the report shows the data at Monthly level.

Am I missing something here? Can the above scenario be achieved using Time Series functions?

If not Time Series, what might be the other options for me?

Thanks!