Subtotal with conditions

[#1]

Hi there,

I would like to calculate the percentage of only one row (see example).

the conditions would be something like this:  Sum (Sales) / Sum (Total Sales) if Brand = A

Example:

Brand	Sales
A	4	20%
B	5
C	11
	20

How to you write this ecuation?

Thanks,

Roberto

[kaushiknsolanki]

Hi,

Try this.

Sum({<Brand = {"A"}>}Sales) / Sum(Total Sales)

Regards,

Kaushik Solanki

[jolivares]

You have two way:

1. Sum(If(Brand='A',Sum(Sales)/Sum(Total Sales))

2. Sum({<Brand={'A'}>} Sales)/Sum(Total Sales))

I prefer the second one...