Categories
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher conditional grouping one group only
Chris E
Rank 1 - Community Starter
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:
0
Answers
-
Will not allow deletion of post. There have been no replies for solution, so post is useless and taking up space. I'm looking for solutions, not unanswered questions.
0 -
Wouldn't a IF statement after the first for-each do the trick?
0