Filtering multiple combinations of two fields in single worksheet

Question

How to filter multiple combinations of two fields in single worksheet? I have id from my data source as 10 digit no - M/A/E/N - store-id.
store id also exist as a separate field along with id . I want to filter using store id and sort according to M/A/E/N orders of those stores must only be shown.

Answer 1

Hi anitha,

Follow below steps:

1. Split the order field and create a new field using calculated field.

Store-id = SPLIT([Order Id],'-',3) and code = SPLIT([Order Id],'-',2)

2. Now put the order id in text shelf, created field in the filter shelf or parameter and show the details of those orders.

Hope this helps you.