How to add an literal value 'ALL' into a list box

[pxu4]

I need to all 'ALL' as an additional value into the list box 'Region'. 'ALL' is not a value in the data list. But I need the dashboard to go to a new sheet when user clicks 'ALL' in the Region list box. I couldn't figure out how to manually add a value into a list box.

[_ylc · Accepted solution]

You can resident load your region table and concatenate to your region table.

E.g. This is your region Table, I created a new field called Display which you will use as the filter.

RegionTable:
LOAD * INLINE [
Region, Display
North, North
South, South
East, East
];

Concatenate (RegionTable) //Concatenate this resident table to your region table and set the value of display to 'ALL'

LOAD Region, 'ALL' as Display
resident RegionTable;