Restricted Key Figure

20 Views

Hi,

I have created a Restricted Key Figure - RKF1.

The restrictions in this are on 1. Base Key Figure- Ammount

2. Debit Credit Indicator- Debit

3. Activity Type - THR

4. Account

Now the data in Activity Type is of the below format

ABCTHR

XYZTHR

S1RTHR

ABBTHR

XYZHRS

X3RHRS

MYXTHR

...

In the Restricted Key Figure we have given the restriction for ACTIVITY TYPE as THR, which is the last three characters of the actual data present in Activity Type. This is not displaying any results as there is no data in Activity type with just the value as THR.

Can anyone let me know a way in which we can pull out the data from ACTIVITY TYPE which has the data ending with THR.

We need to do this at query level.

Thanks in advance.

Madhav