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
Quote from: Amber12 on 13 Oct 2022 01:08:30 PM
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.
I did, yes, and the result was no data available.
I would like to insert image or attach something but...I'm not successful.
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...
Depending on context, you may also need to change the Application property of the filter to After Auto Aggregation.