Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
May be something like this
If(Dimensionality() = 0, Sum({$<Employee = {'Mark Willams', 'Thomas Nguyen'}>} Salary), 'Confidential')
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 ?
May be something like this
If(Dimensionality() = 0, Sum({$<Employee = {'Mark Willams', 'Thomas Nguyen'}>} Salary), 'Confidential')