How to Restrict a Meaure for a range of values in Analytical Application Design with Live CDS Model

[Verdia_Mayank]

Hi,

i have a live CDS data model from backend S/4 hana . i want to only show (Less than or equal to 0) for Variance Qty. my CDS @analytical.Query has variance calculation so i cannot restrict at CDS level. i tried with Story in SAC but there too i am not able to restrict a measure for a value range in Live connection. i am trying to solve this via analytical application and want to learn from your all how that can be achieved.

Yellow highlighted values is what we would like to see as part of the output. this can be easily be done in Analysis for office or Bex Query but something i am unable to achieve it in SAC .

Kindly, provide your inputs. it will be helpful if you can share your code snippets of analytical design as i am new to this area.