Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 jjustingkm
		
			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.
Flag1 is the base for other flags? I would always recommend to post 10 records with different values to understand more better
 jjustingkm
		
			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
