Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
BI Publisher conditional grouping one group only — Cloud Customer Connect
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

BI Publisher conditional grouping one group only

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

Summary

Break one business unit by department depending on certain account ranges

Content

Pleaee help, I'm a novice BI creator.

I need to split group in report depending on range value. The report already has 5 groups, I need the top level group to split when a certain business unit and department value range of values. The split only will happen with one business unit. 

Report is run from PSoft query based on run control in Peoplesoft.

What's the best way to achieve this?

 

Code Snippet

Range Value:
if (DEPTID >= '6325000' and deptid <= '6328000' then
'Funky'
else
''
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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