Relative value (% from total) on top ranks

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Relative value (% from total) on top ranks

swuehl — Fri, 17 Jun 2016 22:58:58 GMT

Try

Sum(sales) / Sum(TOTAL sales)