You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

How to filter by starts-with for 3 RTF columns?

Received Response
8
Views
11
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 11 comments

Summary

How to filter by starts-with for 3 RTF columns?

Content

Hi All,

I have a list of results that I need to evenly show across 3 columns to look like this:

I'm not exactly sure how to do this. One idea I have is to just add a filter in each of the 3 columns for Starts-with 'A to E' for Column 1, ''G to P" for Column 2, "R" for Column 3.

I have the 3 columns built but I'm not sure how to filter the content in each of them.

The group row by code is:

<?for-each-group:row;./FIELDVALUE?><?sort:current-group()/FIELDVALUE;'ascending';data-type='text'?>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!