Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
How can i select numbers in a pivottable.
For example i only want to see numbers 4000, 4030, 4415, 8060 to 8500.
.png) 
					
				
		
 Miguel_Angel_Ba
		
			Miguel_Angel_BaHi,
In what expression do you want to see them? Let's say you are doing a sum of sales.
Sum({< CDGRBREKENING = {4000, 4030, 4415, '>=8060<=8500'} >} Sales)
That will return the sum of values in field Sales for those values only.
Hope that helps.
Miguel
 
					
				
		
If you want to select those, you could create a selectbox having the "grootboeknummer" as a separate attribute
In the listbox you could use this expression:
4000 4030 4415 >=8060<=8500
Make sure your listbox is in AND mode (option on the general tab "use normal search") (otherwise it will search for >=8060 OR <=8500 (....)
Hope it helps.
