Hello Cognos experts. I have created a Crosstab visualization in Cognos analytics Dashboard (not report) in the below format
Month1 Month2 Month3
HeadCount Opening Balance 100 200 300
HeadCount Ending Balance 400 500 600
I need to show a delta at the bottom of a crosstab (HeadCount Opening Balance - HeadCount Ending Balance) as shown below:
Month1 Month2 Month3
HeadCount Opening Balance 100 200 300
HeadCount Ending Balance 400 500 600
Delta 300 300 300
How can i accomplish this? Is it possible in Cognos Dashboarding? Appreciate your suggestions. Thanks in advance
Please note HeadCount Opening Balance and HeadCount Ending Balance is coming from a single column from the source called 'Status'
Create calculated data items like:
Case
When [status] = 'Headcount Opening Balance' Then [Measure]
Else 0
End
Case
When [status] = 'Headcount Closing Balance' Then [Measure]
Else 0
End
Create another data item called [Delta] which will be 2nd - 1st
Thank you so much. on the same lines but little more complicated, I need to show the delta= ending balance of prev month - opening balance of current month. In my example below, I need to show delta as: null 200 200.
Appreciate your valuable time and response