Create custom bins

Riti Malhotra

I am trying to create bins for voluntary turnover headcount and then do a count of locations that fall under each bin- how do I do this in FAW? I had the ability to create custom bins in OTBI . I tried to use a case statement but then the count don't group into the correct bin.

Example

0-15% ; 16-25% ; 26-35% ; 35%+

Raghavendra Raghunath-Oracle

Riti, easier using classic. Pivot view cannot be aggregated using non-numeric columns in dv. You can re-create using the attached analysis xml

Raghu

Vol Turnover by Number of Locations.txt