1 Reply Latest reply on Oct 23, 2012 8:45 AM by Robin Kennedy

# Filter out customers with less than x?  subtotal?

For simplicity let's say I have: 2 dimensions: Customers & Products, and 1 measure: UnitSales

I want to display the UnitSales for all Products for any Customers that have more than xx UnitSales of any single Product. (not total UnitSales)

Let's say xx=10 units of any product.

For example:

Customer1 with sales of ProductA 55, ProductB 22, ProductC 2

Customer2 with sales of ProductA 9, ProductB 9, ProductC 9

Customer3 with sales of ProductA 0, ProductB 11, ProductC 5

Should look like:

Customer1

ProductA     55

ProductB     22

ProductC     2

Customer3

ProductB     11

ProductC     5

Any help is greatly appreciated!

• ###### 1. Re: Filter out customers with less than x?  subtotal?

Tim, you can do this with a Table Calculation.

Create a calculated field with the formula:

WINDOW_MAX(SUM([Sales]))

Then add the field to the view and change the compute method to Product (it's then working out the maximum sales per customer over all the products). Add the field to the Filter shelf and set it to "At least 10".

Example attached.

Hope that helps.