Filter Pane for Sum of Amount?

[tonymakos]

Hi folks - i'm tearning my hair out over what should be a very simple set of tasks here - any help appreciated.

I'm doing a simple-ish set of tables which show customer spend over a filtered time period. In general this will be filtered to just include the last 12 months. I have a pivot tables showing customers down one side, with their total amount of spend as a value, with columns splitting up the products they have bought. Simple enough.

I already have a filter pane for the date obviously, but is it possible to have a filter pane which will enable the tables to only show those customers who have spent over a certain amount? For example, could i have a list that shows £500,£100,£1500 etc and when i choose one of these it only shows those customers in the table whose SUM(amount_spent) is equal to or above that?

Thanks in advance!

Tony

[BrunPierre]

Hi, like this perhaps?

=If(Aggr(Sum(Amount) = 100, Customer, Product), Amount,
 If(Aggr(Sum(Amount) = 500, Customer, Product), Amount,
 If(Aggr(Sum(Amount) = 1500, Customer, Product), Amount)))