Link to home
Start Free TrialLog in
Avatar of Marcos27
Marcos27Flag for United States of America

asked on

Counting Sub Categories in SAP BI4

Hello Experts -

Is anyone familiar with SAP BI4? I'm new to this, and I'm trying to do a simple count by category. So say the object is "color", and each record has a "color" field. I added the "color" object to the report, and now I just want to count the number of reds, blues, oranges, etc., so I want a group of red rows with a count or those, then a group of blues and a count of those.

Any ideas? Do I use "break" or "group"? Thanks. When I highlight the color column and just do a "count", it counts the unique values only. I need to know how many reds, how many blues etc.

Thanks,
Marcos
ASKER CERTIFIED SOLUTION
Avatar of Marcos27
Marcos27
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial