My requirment is i need to calucalte the LAR RATE AND SCAR RATE ..
Some suppliers has scars and some supplier has Lar ..
In the same pivot table i need to calculate for the suppliers their scar rate and Lar rate
To show the user more specific which supplier has scar and lar
And i also need to show the conditional formatting .IF scar is >98 some colour
and also lar >95 some colour ..
Please find screen shot