Hello everyone
I have a pivot table that sorts data based on the date, the goal is to make this more user-friendly so that other people can use it. The pivot data I'm using is outsourced from PowerBI so I don't want to adjust it.
Basically, the date filter for the pivot table sorts the date in the format "yyyymmdd" e.g. "20230915 = 15 September 2023.
There is also 5 sets of data, 2 of which require the last working day, 2 will need to have the date 2 days ago and 1 will need to have the date 3 days ago.
So right now the only way to update the data is to change 5 inputs and use this "yyyymmdd" format.
How can I make it so that there are just 3 user-input fields (last working day, two days ago, three days ago) with the format "dd/mm/yyy" and these change the pivot data filter to the corresponding date in "yyyymmdd" format?
Any help is appreciated
Thank you!
I have a pivot table that sorts data based on the date, the goal is to make this more user-friendly so that other people can use it. The pivot data I'm using is outsourced from PowerBI so I don't want to adjust it.
Basically, the date filter for the pivot table sorts the date in the format "yyyymmdd" e.g. "20230915 = 15 September 2023.
There is also 5 sets of data, 2 of which require the last working day, 2 will need to have the date 2 days ago and 1 will need to have the date 3 days ago.
So right now the only way to update the data is to change 5 inputs and use this "yyyymmdd" format.
How can I make it so that there are just 3 user-input fields (last working day, two days ago, three days ago) with the format "dd/mm/yyy" and these change the pivot data filter to the corresponding date in "yyyymmdd" format?
Any help is appreciated
Thank you!