Show all using Filtering

[Cateleb]

Hi, I saw an example a couple of years ago in the forums but can't now find it again

 

I know I can filter a portal based on a global, but can't work out how to show all.  i've found things about putting a calc field "all" & ¶ ...   but it seems this when the global is set by static value list ... my global is set from a dynamic TO

 

I'm presumeably missing something

 

I think the original example had something like filtering sales based on (US) city and 'show all' obviously took off all the filtering

 

thanks

cate  (still on FM11 in case FM12 has some advancments)

[comment]

You could make your filtering condition show all related records when the global is empty - for example:

 

Parent::gCity = Child::City

or

IsEmpty ( Parent::gCity )