Total different than subtotal

[jamessmith99]

I want the pivot table Totals to display $102,160 and the Employees to display ‘Confidential’. Can this expression be changed to do that?

IF(Sum({$<Employee={'Mark Willams','Thomas Nguyen'}>}Salary)= 0,'Confidential'))

Employee	Salary
Totals	$102,160
Mark Willams	Confidential
Thomas Nguyen	Confidential

[jyothish8807]

Can you please share a sample data you have ? Is salary of two employees "0" in  the data ? And what is total,  is it a entry in the data or is it total of salaries of all employees ?

[sunny_talwar · Accepted solution]

May be something like this

If(Dimensionality() = 0,
Sum({$<Employee = {'Mark Willams', 'Thomas Nguyen'}>} Salary),
'Confidential')