Counting and retaining field values

[mattphillip]

Hoping someone can help me out here. I have customer data with a column dedicated to each particular year. My dashboard currently features two text boxes; one with a total customer count, and the other with a percentage (%) value of the total number of customers. What I'd like to do is have is either a third text box with the percentage (%) value taken from the selected year only OR a box featuring percentage (%) values for each year individually.

Does anyone know whether this is possible. I'm getting myself confused.

Much appreciated.

Matt

[#2]

it works but can u elaborate the code and provide screen shot

[arulsettu]

Hi

try like this

num(avg({<year={$(=max(year))}>}customer),'#,##0%')

or provide sample