Pivot table to show only current year data till previous month (Year to Month period)
Summary:
Need to filter data in a pivot table to show only current year data till previous month
Content (required):
We have pivot table with measure have data in history and future months. Need to create a pivot table with filter to show only current year data (Year to Month period) till previous month. For example if we are in Sep'2023, table should show only date from jan 2023 till Aug 2023 only.
Version (include the version you are using, if applicable):
22C
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0