I have created a report, which links to a pivot table, rows and columns. In this interactive report, I will select from a the filters Customers to display. I however, now noticed that not all customers have information related to all columns. I attempted to select display 'show items with no data on rows or columns', however, I noticed the fields are grayed out.
How do I solve this? I really would not want to disregard this report, other than this issue it works beautifully.
PivotTable Options -> Display -> Show items with no data on rows / Show items with no data on columns (these one is [FONT=arial, sans-serif]grayed out[/FONT] so that I cannot check them)
How do I solve this? I really would not want to disregard this report, other than this issue it works beautifully.
PivotTable Options -> Display -> Show items with no data on rows / Show items with no data on columns (these one is [FONT=arial, sans-serif]grayed out[/FONT] so that I cannot check them)
Last edited:
