I need a help for the below scenario,
If I select any values in Category filter, Account and name list box will show only the non-zero values from the pivot in the list box.
if I select A in category filter, Account filter should show 1 and 3 only and If I select B in category Account should show a and 4 only.
Thanks in advance
Check for Correct answer in below link, maybe that would help?
display row only if all row populated
View solution in original post
You should be able uncheck a couple of options.
Dimensions Tab - Make sure that Show All Values is unticked on all dimensions
Presentation Tab - Make sure Suppress Zero-Values is Ticked.