Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table that has user access against modules.
[User Code] | Module | Administration | Analyse de risque | Analyse des Frais bancaires | Budget de trésorerie | Comptabilisation des Flux | Comptabilisation des Transactions Financières | Comptabilité de couverture | Données de marché | Echange de données | Effets Clients | Effets Fournisseurs | Flux de Trésorerie & Prévisions | Fraud & Compliance | FX | In-House Banking |
ABTEST | Yes | - | - | - | Yes | - | - | - | - | Yes | Yes | Yes | Yes | Yes | - | |
ACOLONNA | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
ADMIN | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
I would like to filter on a user without losing the modules that have null values. When I filter the result looks like this
[User Code] | Module | Administration | Comptabilisation des Flux | Effets Clients | Effets Fournisseurs | Flux de Trésorerie & Prévisions | Fraud & Compliance | FX | Netting | Paiements/Prélèvements | Portail | Pouvoirs Bancaires | Rapprochement Comptable | SCF Factures à Payer | SCF Payables - Portail Fournisseur | Tenue de Position |
ABTEST | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Please see the attachments in the file section. Output expected is below. All modules must be present even if it is null.
[User Code] | Module | Administration | Analyse de risque | Analyse des Frais bancaires | Budget de trésorerie | Comptabilisation des Flux | Comptabilisation des Transactions Financières | Comptabilité de couverture | Données de marché | Echange de données | Effets Clients | Effets Fournisseurs | Flux de Trésorerie & Prévisions | Fraud & Compliance | FX |
ABTEST | Yes | - | - | - | Yes | - | - | - | - | Yes | Yes | Yes | Yes | Yes |
Thanks in advance