Hello,
I am trying to make a pivot chart that holds all of my supplier information based on some of my key performance indicators. I want the Pivot to automatically filter to not show the suppliers that have no value in the current month, as they have not been used.
Here is a sample of what the Pivot looks like.
In the sample, the last two suppliers should be filtered out.
I am trying to make a pivot chart that holds all of my supplier information based on some of my key performance indicators. I want the Pivot to automatically filter to not show the suppliers that have no value in the current month, as they have not been used.
Here is a sample of what the Pivot looks like.In the sample, the last two suppliers should be filtered out.
