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.
