Query Regarding Excluding Measure Data (<= 600) in Custom Analytical Querie

[Ruchi691]

Dear SAP Support Team,

I am working on a Custom Analytical Query(yy1_Report)  in SAP S/4HANA Cloud using the Custom Analytical Queries app. My goal is to exclude rows where the measure Amount in Company Code Currency is less than or equal to 600 (<= 600).

However, I have observed that:

1. Filters are not directly applicable to measures in the query designer.
2. I need to find a way to either exclude these rows from the query result or create a restricted view that meets this condition.

I want to exclude all rows where Amount in Company Code Currency <= 600 and display only rows with values greater than 600.

---

Example Data:

GL Account Document Number Posting Date Amount in Company Code Currency

100000	12345	2024-01-01	500
200000	12346	2024-01-02	700

Desired Output:

GL Account Document Number Posting Date Amount in Company Code Currency

200000

12346

2024-01-02

700

Could you please suggest, since it is very urgent.

Note: we want to filter on the consolidated amount hence we cant do it in CDS view level we need to perform this in query level.

Thanks and Regards

Ruchi Kesharwani