good afternoon
Is anyone able to assist please, i'm trying to count i.e. Cover Type at Policy level, NOT cover level where the cover type is either Buildings or Contents and if they have both it's to be Combined i.e. example below refers. I have got it to work if i incorporate the Cover Type Dimension but i don't want to. Am Using a Table
look forward to hearing from someone
data |
|
summary as to what I'm after |
policy no |
cover type |
|
Policy No |
Buildings |
Contents |
Combined |
AAAA |
Buildings |
|
AAAA |
0 |
0 |
1 |
AAAA |
Contents |
|
BBBB |
1 |
0 |
0 |
AAAA |
garden |
|
CCCC |
0 |
1 |
0 |
AAAA |
TV |
|
|
|
|
|
BBBB |
Buildings |
|
|
|
|
|
BBBB |
garden |
|
|
|
|
|
CCCC |
Contents |
|
|
|
|
|
CCCC |
TV |
|
|
|
|
|
CCCC |
garden |
|
|
|
|
|