A somewhat complicated set analysis problem

[Anonymous]

Hi everyone!

I'd like to consider myself a intermediate to moderate set analysis user, but I have a scenario that I just can't seem to wrap my head around.

What I'm trying to do is get the total (in $) of orders, which are at a part/customer/fiscal qtr level, BUT only where the total of the part/customer/fiscal qtr level item is greater than a particular value.

For example, I have three parts (A through C), and each part is purchased by customers 1 through 3. I want to get a total of the orders for all parts and customers, but only for the big buyers, where their orders are over $1,000,000.

I've tried using AGGR(), RANGESUM(), and different methods of using the ONLY() function, but nothing I'm trying seems to work.

Any thoughts/ideas/help?

[sunny_talwar · Accepted solution]

May be this

Sum(Aggr(If(Sum(Orders) > 1000000, Sum(Orders)), Part, Customer))

[Anonymous]

That absolutely did the trick! Thank you so much!