0 Replies Latest reply on Mar 14, 2013 3:31 PM by Tim Christ

Previous ? has become more complicated...

Got a great answer to my previous question, the Table Calculation worked great, but now things are a bit more complicated.  I need to do the same analysis, but now with the element of time.  So the same problem as before, using monthly sales data instead of sales totals.

I'm having problems combining running total calculations with table calculations, if that's even possible?

New Example also attached since I doubt this is readable.

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!

Correct Answer by Robin Kennedy  on Oct 23, 2012 8:45 AM

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.