-1

I want to designed a report in a cognos which showcase data for current month or prevoius month choice on prompt page, need to get logic for this. Please advice if any one has solution for this...

VIRAL_ZONE
  • 35
  • 7
  • 1
    Hi @VIRAL_ZONE, please provide some sample data. – Vishnu Kunchur Oct 13 '18 at 19:00
  • Hi Vishnu, i have data for some Dealers (say Dealer code,name,contact etc) – VIRAL_ZONE Oct 13 '18 at 19:53
  • Hi Vishnu, i have data for some Dealers (say Dealer code as identifier,name,contact etc), date column as Reporting Month (data type as date & format is 'YYYYMM') ...Report Prompt should filter on Dealer Code, and Current Month or prevoius month logic... Let me know if you want more clarrification... – VIRAL_ZONE Oct 13 '18 at 19:58
  • There isn't enough information for us to understand the question. Please add the table structure to the question. – The Impaler Oct 13 '18 at 20:56
  • Not very sure what you are asking as you have not given much details, but if its just about the month fetch logic then you can use MONTH(COL_NAME) = MONTH(CURRENT DATE) and MONTH(COL_NAME) = MONTH(CURRENT DATE - 1 MONTH) for previous month – uSeruSher Oct 15 '18 at 15:34

1 Answers1

0

2 suggestions

Scenario 1) Put the current month and prior month values in a conditional block

Or if you don't want to do that,

Scenario 2) Create two lists One each way you want to present the data

  • Current Month
  • Prior Month

Then use rendering on the prompt to show the list the user selected

VAI Jason
  • 389
  • 2
  • 10