Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this.
Sum({<Brand = {"A"}>}Sales) / Sum(Total Sales)
Regards,
Kaushik Solanki
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...