Aggregate Percentage

[#1]

Hi,

I am trying to show the percentage of a field with three distinctions.

Company	Division	=sum(sales)	Total Company Sales
A	A1	10	55
A	A2	20	55
A	A3	25	55

At the moment when I calculate the total using the expression  =aggr(sum(Sales),Company) , I am only getting the total company sales for one division.

How can I get it for all?? So I can then work out the percentage sales as a total?

[#2]

hi

try this

aggr(sum(Total Sales),Company)

[hic · Accepted solution]

You should not use Aggr() for this. You should use the total qualifier:

The total sales, entire selection: Sum( total sales )

The total sales, within company: Sum( total <Company> sales )

So your percentage should be calculated through

     Sum( sales ) / Sum( total <Company> sales )

HIC

[#4]

hi

try this

sum(Sales)/SUM(TOTAL {1} Sales)

[#5]

Great Thanks, Working now

[hic]

See also The Aggregation Scope and When should the Aggr() function NOT be used?

HIC