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.
Only 108 would show in ''Table1" the rest are ‘empty’
a help would be appreciated.
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.
Some screenshots below:
Thank you, really appreciate it