Show ONLY duplicate records in a Pivot Table with subtotals?

[jschuellhma]

I am new to QlikView, so please bear with me.

I am trying to put together a pivot table that looks like the following :

Employee	Department	Payroll Date	Wages Paid to Date
Mary Smith +	Accounting		$10,000
Mary Smith	Accounting	6/1/2015	$5,000
Mary Smith	Accounting	6/15/2015	$5,000
John Jones	IT		$3,200

I have a table of employees that shows how much they have been paid to date, what payroll dates they participated in and how much they were paid on those dates.  This view shows what it would look like when Mary Smith is expanded.

I am only interested in showing Mary Smith in this case, i.e. I only want those employees who have participated in multiple payrolls.  Is there a Pivot Table setting or an expression that can be written which will produce this result, and continue working when there's an update and John Jones participates in a second payroll?

Let me know if this is unclear and I'll try to rephrase.  Thank you in advance!

[stigchel]

Try with a calculated dimension, something like

if(aggr(Count([Payroll date]),Employee)>1,Employee)

[ramoncova06]

another way is to add a search in your set analysis, this way you do not have to suppress null values

=sum({<Employee={"=Count([Payroll date])>1"}>}Wages)