Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to sum just part of the FACTS in this way:
Suppose Facts Table
Customer Sales
A 20
B 20
C 30
A 50
I want an expression with total sales from Customers with sales greater then 60, in this case it would be 70.
What would be the expression?
Thanks in advance.
Prata
This can be another way to do it, if you are doing this in a text box object:
Sum(Aggr(If(Sum(Sales) > 60, Sum(Sales)), Customer))
for a straight table use the below expression with Customer as your dimension
If(Sum(Sales) > 60, Sum(Sales))
Use set analysis with an advanced search in customer field:
=Sum({<Customer = {"=Sum(Sales)>60"}>} Sales)
This can be another way to do it, if you are doing this in a text box object:
Sum(Aggr(If(Sum(Sales) > 60, Sum(Sales)), Customer))
for a straight table use the below expression with Customer as your dimension
If(Sum(Sales) > 60, Sum(Sales))