Hi,
Here is what my dashboard looks like:
It has list dropdowns for category (All, East, West, North, South) and month (All, Jan-16, Feb-16,...Dec-16).
The chart is populated from a pivot table based on the selection from dropdown for category and/or month.
Now every category does not have corresponding data for every month (eg. there is no data for East for Jan-16). This is when I get the Error(No item of this name exists in PivotTable report. Rename "East" to "West"). And if selected OK, this creates a mess with the pivot table.
The workaround I thought was to search the base data with the combinations of category and month, before the pivot filters change on category and/or month.
But not sure how to write the code.
Any other workaround is also welcome.
Thanks.
Here is what my dashboard looks like:
It has list dropdowns for category (All, East, West, North, South) and month (All, Jan-16, Feb-16,...Dec-16).
The chart is populated from a pivot table based on the selection from dropdown for category and/or month.
Now every category does not have corresponding data for every month (eg. there is no data for East for Jan-16). This is when I get the Error(No item of this name exists in PivotTable report. Rename "East" to "West"). And if selected OK, this creates a mess with the pivot table.
The workaround I thought was to search the base data with the combinations of category and month, before the pivot filters change on category and/or month.
But not sure how to write the code.
Any other workaround is also welcome.
Thanks.