I'm trying to get a Workbook pivot with two columns consisting of separate period ranges. Is this possible? It looks to me like when you have two columns using the same field it won't let you set distinct filters on each one.

Hello James, it is true that period over period comparison is not supported directly at the moment. You can achieve something similar using Formulas, we listed some of the most popular here: https://community.oracle.com/netsuite/discussion/4470920/workbook-datataset-formula-fields-time-operations Let me know if this helps in your case

That's a good idea, but unfortunately doesn't solve my particular use case. We changed FYs, and have a 3 month stub year, so I need the ability to do custom period range comparisons, since YoY reporting is really rolling 12/13/15 months reporting and not same period last FY (hence standard reports period selections not working for this either). With multiple scenarios of how non-technical resources would want to look at period comparisons, changing the formulas every time is not really feasible. Helpful to know it's definitely not supported though, so I at least know to take a different tack. Thanks!