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
Now the data in Activity Type is of the below format
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.