Conditional SUM

[Anonymous]

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

[swuehl]

Use set analysis with an advanced search in customer field:

=Sum({<Customer = {"=Sum(Sales)>60"}>} Sales)

A Primer on Set Analysis

[reddy-s]

Hi Ricardo,

This should help you as well.

Set Analysis: syntaxes, examples

[sunny_talwar · Accepted solution]

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))