Ifelse statement based on count in a Pivot table

Hi ,
Currently looking for a way to create a calculation in Pivot.

where if count of Table1 is equal to the count of Table2 , then return ‘blank’
if not then return the current value.

Output

Desired Output
Only 108 would show in ''Table1" the rest are ‘empty’

a help would be appreciated.

Hi @edward

Barring any complexity on your data, this should be achievable using a calculated field for ‘table1’ and ‘table2’. To get the desired format make sure to select ‘row’ as display type for pivot.

Please let me know if this helps and if it does please mark as solved.

thanks!
Ramon Lopez
Some screenshots below:

image

image

Thank you, really appreciate it

1 Like