Overlapping values in dimension

[jjustingkm]

Hi All,

I have a scenario like below.

I have to display four counts based on an indicator, the problem is that some counts can repeat like below.

flg1 flg2 flg3 flg 4                                flg1 count  flg2 count flg2 count flg3 count

y     y          n    n                                        2                       1                         0            0

y     n         n   n 

what is the best wat to display this. thinking about a dimension like type with four values and the numbers but the numbers should  overlapp. any thoughts.

[Anil_Babu_Samineni]

Flag1 is the base for other flags? I would always recommend to post 10 records with different values to understand more better

[jjustingkm]

They are all independent columns.  But the problem is that two id can be true for same id.

id  flg1 flg2 flg3 flg 4  

1     y     y          n    n                                        

2    y     n         n   n