what happens to new years/dates ? if you have to define manually each axis-value/column, this is not the expected pivot functionality like e.g. in Excel :-(
If you have multiple years in the future, just provide those future years in advance in the axis values to future proof it. This way you'll make sure it covers 5-10-15 years in the future.
Thanks for sharing knowledge :)
what happens to new years/dates ?
if you have to define manually each axis-value/column, this is not the expected pivot functionality like e.g. in Excel :-(
If you have multiple years in the future, just provide those future years in advance in the axis values to future proof it.
This way you'll make sure it covers 5-10-15 years in the future.