Report - Filter condition based on aggregation result

[adilbelahbib]

Hey,

I created a report on the alm_asset table, I want to display 'only' the records having the sum of their quantities below a value contained in another field. in the 'Filter Condition' zone, I can't filter based on the SUM calculated by the aggregation option.

Any ideas ?

Thanks in advance.

[sagaragarwal1]

Hi Adil,

You can try with pivoted type report with aggregation as count.

Choose the columns and rows according to you need. It would provide you a sum of fields.

For more info view this article : Pivoted table type report

[adilbelahbib]

Thanks Sagar for the answer.

Actually I was already on that road, but what I need to do is filter based on that count (or sum in my case), for example show only the fields having the sum under alm_model.threshold

[Vidhya A]

Did you get answer for this? I am looking for similar solution.