Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 stabben23
		
			stabben23
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
I have a stockbalanse for every day. I want to show this on a week and month level in a pivot.
when I use week as dimension I want to show the last days value in that week and if I use month I want to show last day in month value.
Load * Inline [ Date, stockvalue 20140617 11775520 20140618 11578401 20140619 11340838 20140620 11340838 20140621 11340838 20140622 11340838 ];
 
					
				
		
 CELAMBARASAN
		
			CELAMBARASAN
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try with this
FirstSortedValue(stockvalue, -Date)
 stabben23
		
			stabben23
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Like this but with value 11 340 838 for week 25

 stabben23
		
			stabben23
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I think I need to explain that I dont have the total stockvalue on every day, I have to do a sum over all items.
 tresesco
		
			tresesco
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		If you could post a qvw with sample data and explain expected output against that data, would be much easier for us and faster (to get answer) for you.
