Relative value (% from total) on top ranks

[Anonymous]

Hi,

I have a table with sales data.  I have filtered my data by year and month.

In my table I have

year - month - branch - sales

I have ordered my table for sales descending and limited number of dimensions values to 10.

Then I have top 10 branches for a  year-month selection. I have a total of 47 branches.

Now I want to add a new expresion to my table

%(sales of a branch)/(total sales). for total I mean the 47 branches

I can't do it using 'relative value' as a option of expresion presentation, because with this option I have:

%(sales of a branch)/(total sales of top 10).

How can I get %sales of a branch/total sales of total (the 47).??

All my data is filtered by year and moth selected in lisboxes.

Thank in advance

[swuehl]

Try

Sum(sales) / Sum(TOTAL sales)