If you are unable to create a new account, please email support@bspsoftware.com

 

Need to show previous years december data when year filter is selected

Started by raghunori, 21 Jul 2023 01:44:24 AM

Previous topic - Next topic

raghunori

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?