Filter by calculated field

[Amber12]

I have a report that shows gross margin per customer. Each customer can have multiple customer numbers. So the report gives me the GM% per each customer number and I have a calculation for GM% for the customer as a whole. I would like the report to show me only the customers that in TOTAL have a GM% under let's say 10%. How could I do that? When I set up a filter for GM%1 (the name of my calculated field) <0.1, the report is no longer showing the values for customer numbers that have GM% less than 10%.
I tried to attach a "created" representation of my report but for some reason didn't work.
Any help it's appreciated.
Thank you

[MFGF]

I have a report that shows gross margin per customer. Each customer can have multiple customer numbers. So the report gives me the GM% per each customer number and I have a calculation for GM% for the customer as a whole. I would like the report to show me only the customers that in TOTAL have a GM% under let's say 10%. How could I do that? When I set up a filter for GM%1 (the name of my calculated field) <0.1, the report is no longer showing the values for customer numbers that have GM% less than 10%.
I tried to attach a "created" representation of my report but for some reason didn't work.
Any help it's appreciated.
Thank you

Hi,

I'm assuming the filter you are using at the moment is a Detail filter? Have you tried defining a Summary filter rather than a Detail filter?

Cheers!

MF.

[Amber12]

I did, yes, and the result was no data available.
I would like to insert image or attach something but...I'm not successful.

[Amber12]

I just changed the filter to >0.2 and it worked. I don't understand why would not work with <0.2 because there is data less than 0.2...

[dougp]

Depending on context, you may also need to change the Application property of the filter to After Auto Aggregation.