Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Bex Query to find total number

Dear Friends,

I have data like below in my Infocube for different years. its flat file loading  DS->DSO->Infocube.

EmpIdDeptsectionYearSmoking
101HRAJan-10No
102HRAJan-10Yes
103HRBJan-10Yes
104FIAJan-10No
105FIBJan-10No
102HRAAug-10

No

My requirement is like below to find out total number of employees who are Smokers and non smokers.

DeptYearTot no of EmpTot Emp SmokingTot Emp non-smoking
HR2010321
FI2010202
Result52                                    3

Please give me your valuable input

Thanks

Vijay

Tags:
Former Member
replied

This should be easy

  1. Make one CKF and put 1 inside it.
  2. Drag this CKF in columns panel--Right click on it--drag smoking char in it and restrict it with value = Yes.
  3. Repeat the same step for finding non smoking and total employee.

Regards,

AL

2 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question