I need to retrict the Key figure(ZPERCENTAGE).
if I have a variable called 'status'.In this status if I have records like Not Achived,Partially Achived, Achived.
If I select Not achived, I need to display some records those are bellow 59(ZPERENTAGE).
If I select Partially Achived, Ineed to Restrict the records in between 60 to 99.
If I select Achived,I need to Restrict the records greater than 100.
But from my source sysytem there is NO STATUS field.
How do I create the status field in the query if so then how do I load the data into status filed.
If it is not possible to create the status filed in the query, then how do i achive this issue.
can any one assist me on this please.