topic Conditional show/hide similar column names in Pivot table - New Task in App Development

Conditional show/hide similar column names in Pivot table - New Task

tajmohamed30 — Sat, 21 May 2022 05:49:45 GMT

Hi all,

In my pivot table I try to conditionally show below Fields with similar name

Vendor_Country & Vendor

Issue - when I select Vendor Country, the Vendor is also getting displayed in the pivot

I use separate filter pane object to choose required fields to display in table using below expression and this expression shows only required fields need to display in filter object

=Aggr(
Only({1<[$Field] = p({1<[$Field] = { "Vendor",,"Vendor_Country"}>})>} [$Field])
, [$Field])

and I use below expression in conditional show for those two fields to hide or show according to the user selection

=count(GetFieldSelections($Field)>0) and substringcount(concat($Field),"Vendor_Country") --- for Vendor_Country

=count(GetFieldSelections($Field)>0) and substringcount(concat($Field),"Vendor") ------ for Vendor

Could anyone please help where do I need to correct or add any expression so that only Vendor_Country alone displays in pivot when I select Vendor_Country in filter instead of displaying both fields

Re: Conditional show/hide similar column names in Pivot table - New Task

rubenmarin — Sat, 21 May 2022 07:43:55 GMT

Hi, thats because 'Vendor_Country' contains 'Vendor', try adding separators to limit values, something like:

substringcount('|'&concat($Field,'|')&'|','|Vendor_Country|')

substringcount('|'&concat($Field,'|')&'|','|Vendor|')

Re: Conditional show/hide similar column names in Pivot table - New Task

tajmohamed30 — Sat, 21 May 2022 10:25:27 GMT

getselectedcount($Field) > 0 and match($Field,'Vendor_Country')

getselectedcount($Field) > 0 and match($Field,'Vendor')

Finally found the solution after spending hours and by combining ideas from different forums 🙂

Thanks all, I hope this solution might help someone in future

Re: Conditional show/hide similar column names in Pivot table - New Task

tajmohamed30 — Sat, 21 May 2022 10:26:15 GMT

tried but haven't anyway found the solution thanks