Calculate Average For Single Item Below list

[dbrooks74]

Data:

Color	Value
Red	2
Blue	10
Green	7

Avg Blue: 53%

How do I create the calculation for the percentage?  Basically I have a column for an item then I have a column for a value.  I would like to a select value and divide that by the total values. 

Is this possible?

Thanks

[MFGF]

Hi,

How about a calculation:

total([Value] for [Colour]) / total ([Value] for report)

Then format it as percent.

Does this give you what you need?

MF.

[dbrooks74]

Thank you. 

Sometimes it takes another set of eyes.  I was trying to use the summary function rather than calculation.  That works perfectly!

[MFGF]

You're welcome!  :)