To show Delta at the bottom of a crosstab

[raghunori]

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'

[cognostechie]

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

[raghunori]

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