Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
I have a set analys that works very good but I would have a new chart on the same sheet that show another
product without choosing it from a field box. I have the set in an variable and have tried to extend it but it doesn´t work.
PeriodID = {$(=Max(PeriodID))},{<MaterialNr={D102328}>},
 Year = ,
 Quarter= ,
 Month= ,
 Period= 
this expands the variable:
Sum({$<$(DNEYE)>} [DebPris]/100)
And this is what I like to achieve:

I have tried a lot of different things to get the value only for this MaterialNr
kindly
Håkan
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		PeriodID = {$(=Max(PeriodID))},
MaterialNr={'D102328'},
Year = ,
Quarter= ,
Month= ,
Period=
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		PeriodID = {$(=Max(PeriodID))},
MaterialNr={'D102328'},
Year = ,
Quarter= ,
Month= ,
Period=
 
					
				
		
Thanks for a very fas response.
Håkan
