Average for Sales Area

[ValeriaBonini]

Hi, I have a table like this

NAME     AREA         SALES      SALES%                                                                             AVG % Sales per area

name1    area1           10            sum(sales)/sum( total <NAME> sales)                  ???????

name2    area1           10

name3    area2         20

name4    area3        30

name5    area3        5

name6    area3           10  

How can I calculate the average % sale for Area?  

[Chanty4u]

Try this expression

sum(SALES) / sum(total <AREA> SALES)

[anat]

Sum(sales) /Sum({1} Total sales) 

[Chanty4u]

Try this 

Avg({<AREA>} SALES_PERCENTAGE)

[vinieme12]

this is a something that you may want to confirm with your users