I am trying to make a list of all suppliers my company has used this month. I want the pivot table to show the rolling 12 month period of the information, but only show the suppliers that have a value for the current month. Currently it will only show this current month of data and not the full 12. How do I go about getting all 12 of the rolling period to show but only for the suppliers that the company has used in the current month?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Help with getting the correct information to show in my sliced pivot table
Similar threads
- Question
