Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 priyarane
		
			priyarane
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi Community,
Currently I am using below expression to associate of non associated values(GA 6- 'A.08', 'A.08a', 'A.08b') to lineno 129K. This working perfectly but now with only dimension of Lineno but now we are adding other dimensions as well then it is not working as expected. Can any one please advise on this.
If(Only({1}LineNo) = '129k', Sum(TOTAL {<GA6 *= {'A.08', 'A.08a', 'A.08b'}, LineNo>} BSAmount), Sum(BSAmount))
Refer: Associating UI level if possible this to have more clarity on this.
_Priya
 
					
				
		
 jyothish8807
		
			jyothish8807
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Can you try like this:
If(Only({1}LineNo) = '129k', Sum(TOTAL {<GA6 *= {'A.08', 'A.08a', 'A.08b'}, LineNo, NewDimension>} BSAmount), Sum(BSAmount))
Br,
KC
 
					
				
		
 jyothish8807
		
			jyothish8807
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Or let us know what is the new dimension you are adding, a sample will be helpful.
Br,
KC
 priyarane
		
			priyarane
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		there are couple of dimension(50+)
still this expression is not helped.
If(Only({1}LineNo) = '129k', Sum(TOTAL {<GA6 *= {'A.08', 'A.08a', 'A.08b'}, LineNo, NewDimension>} BSAmount), Sum(BSAmount))
