Filtering on items that are defined two different levels

[Taboka]

Hi all,

I have data appearing as follows:
Service Type      Geographical Grouping   
SMS                          National
SMS                          International
SMS                          Roaming
MMS                          Visitor
MMS                        International
MMS                              National
Outpayments              International   
Outpayments              National

Now I would like to see SMSs only under National Geographical grouping,MMSs under all Geographical groupings and Outpayments only under National Geographical grouping.
Now,filtering on National Geographical grouping will be incorrect since I would like to see National MMSs.
So how do I filter on National such that its tied to only SMS and Outpayments Service Types?

Thanks\Regards

Taboka

[almeids]

Concatenate your Service Type and Geographical Grouping and filter on the concatenated value, or, if your filter is a permanent requirement, construct a single filter in the format:
((([ST]='SMS' or [ST]='Outpayments') and [GG]=National)) or ([ST]='MMS'))

where ST and GG are your data items.  Change the last part to...

or ([ST] not in ('SMS','Outpayments'))

...if you want to allow for additional STs without a GG filter

[Taboka]

Hi,
Thanks for the response,what I evetually did was to create a data item which contained a case statement besad on the items I wanted to see.I then filtered based on that data item and it worked.But for interest sake I'l try concatenation as you've suggested.

Thanks\Regards

Taboka