Hi,
I have a chart that shows the Gross Profit of each Product Group Class, but I want to show a marker or indicate somehow that the Gross profit of an Item within any given Class is below a certain % threshold.
example
Threshold is 15%
Product Class A overall is 18.75% so OK
Product group 1 overall is 17.5% so OK
Item A1 GP is 10% so BAD
Item B1 GP is 25% so OK
Product group 2 overall is 20% so OK
Item A2 GP is 20% so OK
Item B2 GP is 20% so OK
Product Class B overall is 20% so OK
Product group 3 overall is 20% so OK
Item A3 GP is 20% so OK
Item B3 GP is 20% so OK
Product group 4 overall is 20% so OK
Item A4 GP is 20% so OK
Item B4 GP is 20% so OK
I want to show Product Class A as OK because overall it meets the threshold, but indicate that there is a problem at a lower level, so the user can investigate and find that Item Code A1 is a problem.
Thanks
Steve