I create a pivot table. Drag and place date into the filter field.
I am trying to automate the filtering of date to the previous working day so that the table will be updated daily.
Please help me thanks a lot!
I create a pivot table. Drag and place date into the filter field.
I am trying to automate the filtering of date to the previous working day so that the table will be updated daily.
Please help me thanks a lot!
Please post a sample workbook so that we can manipulate data specifically to your case. Do not post a picture as we cannot manipulate data in a picture.
Don’t have an account yet? Register yourself now and be a part of our community!