You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!