BI Publisher conditional grouping one group only
SummaryBreak one business unit by department depending on certain account ranges
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?
Range Value: if (DEPTID >= '6325000' and deptid <= '6328000' then 'Funky' else ''