Calculacted KF at cube or report level

[Former Member]

How can I achieve this?

HANDLING UNIT (Handling Unit Number- CHAR 10)

Restricted with RECTY=3 & ACTIV=2 Sort on HU and count distinct

The action to be performed is the Handling Unit should be first restricted by Info Obj RECTY=3 and ACTIV=2 Then sort on HANDLING UNIT and count No of Distinct Handling Units.

How can i acheve this...

can i acheve this at cube leve or at report level

Thanks

[Former Member]

Create a CKF where you need to use Count Function for Handling Units.

Now in your Selections: Put (RECTY=3 & ACTIV=2 and CKF you created)

Now that would display distinct count of HU only where ACTIV = 2 and RECTY = 3.

If you put the HU in rows, it will be sorted by HU by default.

thanks.

Wond

[Former Member]

Hi

Thanks for info provided.

But i want to first sort on Handling Unit No and then count only distinct no of handling units

Thanks

[Former Member]

Hi

Create a restricted kf first for the needed selection

Second create a calculated kf and in this use the restricted kf

This will solve your problem

Regards

N Ganesh