Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hello! Pls. help me solve my problem...I've been stuck with this issue for days... I have a chart table that some values in my total value (under Expressions tab) got duplicated while some were ok... My formula is just simple
({<Source={'Category}>}TotalValue) ....If i put the total value field in the dimensions, computaions seems ok ... But it doesn't allow me to take out the expressions 'coz it will give me 0 records.. Not sure if it has something to do with the synthetic table which I have trouble i fixing it... I also tried switching to pivot table to no avail.
Pls. help.
Tks.
 
 
					
				
		
try this
sum( distinct {<Source={'Category}>}TotalValue)
 Clever_Anjos
		
			Clever_Anjos
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		you´re missing a quote after "category", did you noticed it?
sum({<Source={'Category}>}TotalValue)
 
					
				
		
Thank you,  Vishwaranjan...this one works.
