Chart value at high level but show if lower level doesn't meet criteria

[Stephen.McGrath]

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