topic Re: Total different than subtotal in App Development

Total different than subtotal

jamessmith99 — Thu, 11 Apr 2019 08:22:28 GMT

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

Re: Total different than subtotal

jyothish8807 — Thu, 11 Apr 2019 08:46:34 GMT

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 ?

Re: Total different than subtotal

sunny_talwar — Thu, 11 Apr 2019 11:07:35 GMT

May be something like this

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