Create Prompt for Year and Period between Two Values

[epurwanto]

Hi Cognos gurus,

I really need help.  I'm creating a financial report with prompt page that requires users to input from/to year & period.

[Year] = 2020, 2019
[Period] = 01, 02, 03, 04
[Expense] = various amounts

How can I create a prompt for users to get the total expenses between two year & period?  So if user would like to see how much was spent from quarter 2 to quarter 2 of the following year, they will input 2019-02 and 2020-02.

Thanks!

[BigChris]

Ok, the way I'd probably go about that is to create a calculation for year/quarter:
[Year] || '/' || case
  when [Period] in ('01', '02', '03') then 1
  when [Period] in ('04', '05' etc.
else null
end

Then your filter would just be [Year/Quarter] between ?Begin Year/Quarter? and ?End Year/Quarter?