Hello SMEs.. I need to create a crosstab visualization in Cognos Analytics Dashboard as shown below
Jan2023 Feb2023 Mar2023 Apr2023 May2023
Opening Balance 3000 5000 2000 1000 7000
Looked pretty straight forward first time. But there is also a requirement that they need to have an year filter that they should be able to select current year (2023) or previous year (2022)
When they select a year, for eg: 2023, the crosstab should show current years MoM data and previous years december data like below
Dec 2022 Jan2023 Feb2023 Mar2023 Apr2023 May2023
Opening Balance 50000 3000 5000 2000 1000 7000
Any ideas how to accomplish this?