IBM Business Analytics

 View Only
Expand all | Collapse all

selected period and selected period - 2 (means 202501 and 202411)

  • 1.  selected period and selected period - 2 (means 202501 and 202411)

    Posted 19 hours ago

    Hi,

    I have one report which shows following columns.

    ProductName Sales
    P1 100
    P2  200

    I have a report where the user can select a "period" value, which is passed through the parameter "pPeriod". In the query (Query1), I apply a filter condition like Period = ?pPeriod?, so the report shows sales data for the selected year.

    Now, I would like to enhance the report. If the user selects "202501" (representing the year 2025, period 01), I would like the report to display two columns: one showing the sales data for the selected period, and another showing the sales data for the period from two months prior (e.g., 202411).

    Could you please assist me in implementing this feature? Thank you for your help!

    ProductName Sales202411 Sales202501
    P1 90 100
    P2  110 200


    ------------------------------
    Max Ray
    ------------------------------