narrative for prompted values only

Question

In Answers, on a dashboard, I have 30 column variable prompts.  When user prompts 3 fields --- lets say, Fiscal Year, Program Name, Region -- I would like to include narrative at bottom of dashboard page that says ... "The Report above is for FY16 results for March Madness Program in North America"  Or  "Results are for FY=FY16; Program Name = March Madness; Region = North America.

Since there are 30 column variable prompts, I don't want to see "column a = none; column b = none; FY=FY16; column d = none; Program Name = March Madness; column f = none; Region = North America ... column nth = none?

Can you help me out?  Is there a better way than using "narrative" view?

Thomas Dodds · Answer

Something like ... 'The Report above is for ' || CASE WHEN '@{FY}' <> '' THEN '@{FY} results for ' ELSE '' END || CASE WHEN '@{Program Name} <> '' THEN '@{Program Name} Program in ' || @{Region} ELSE '' END

J Weis-Oracle · Answer

Hi Thomas.  Could you screenshot your idea?  J

J Weis-Oracle · Answer

Thanks Choracy.  I am not sure this'll work as it'll only show data in the first row, just for those particular columns.  What if user prompts for two regions and 3 quarters and 4 programs ... the narrartice would only show 1 region, 1 quarter and 1 program. J