Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here is the data .
center code | cedent cd | cedent name | geo | cont # | Amt1 | Amt2 | Am3 |
X | 123 | DFGH | CENTRAL | X345-2011 | 0 | -524 | 300 |
X | 123 | DFGH | CENTRAL | X345-2012 | 12 | 56 | -467 |
X | 123 | DFGH | CENTRAL | X345-2013 | 0 | 0 | 534 |
X | 123 | DFGH | CENTRAL | X345-2014 | 6 | 0 | -234 |
X | 123 | DFGH | CENTRAL | X345-2015 | 1 | 4 | 23 |
X | 123 | DFGH | CENTRAL | X345-2016 | 0 | 0 | 34 |
X | 123 | DFGH | CENTRAL | X345-2017 | 2 | 0 | -45 |
X | 123 | DFGH | CENTRAL | X345-2018 | 0 | 4 | 23 |
And I need to show as mentioned below.
center code | cedent cd | cedent name | geo | Amt1 | Amt2 | Am3 |
X | 123 | DFGH | CENTRAL | 21 | -460 | -400 |
Data should roll up to cedent level but AMT1,AMT2, AMT3 should be displayed values only when AMT1<>0 OR AMT2<>0
How to achieve this using set analysis? please provide pointers.
Please see the attached file for the code: