Pivot Table

[#1]

Hi friends, I have a question:

I have a pivot table with 4 fields: Country, Code, Person, Sales.

I want to get a new table with records of the above pivot table that sales is greater than 10000$.

I need to report new table by Email or PDF file.

TNX

[marcus_sommer]

You will need a calculated dimension as filter in one of your dimension for this, like:

if(aggr(sum(Sales), Country, Code, Person)>10000, Country)

and then hiding NULL within this dimension: Calculated Dimensions

- Marcus