Hi - I want to bring back all clients associated with selected NAICSDescription value even when no values in GPSMISTOT_REV field in a pivot table for a product. For ex, I have a Client ID and Client Name in my dimensions and expression is shown below.
It works if I select one NAICS Description value and it shows all clients associated with this NAICS even when there is zero using 'suppress zero values' unchecked.
But the problem is if I select one client then it does not bring back other clients associated that NAICS. It works only when there is a value in GPSMISTOT_Rev but does not show up if it's zero for products.
