	<link href=".../External/TelerikCSSFiles/kendo.common.min.css" rel="stylesheet" />
    <link href=".../External/TelerikCSSFiles/kendo.default.min.css" rel="stylesheet" />

<script type="text/javascript" src=".../External/jquery.min.js"></script>
    <script type="text/javascript" src=".../External/kendo.all.min.js"></script>

    <!--<script type="text/javascript"src=".../External/jquery.SPServices-2014.01.min.js"></script>-->
    
 <script type="text/javascript"src=".../External/tavs.js"></script>
 
 
 
<div id="example" class="k-content">
							<input name="Submit1" type="button" value="submit" onclick="getgrid()" /><input name="Text1" id="txtorg" type="text" /><input name="Text2" id="txtorg2"type="text" /><div id="grid" style=" margin:20px;">
							</div>
							<div id="grid2" style=" margin-top:20px" ></div>

						</div>

<script>
	function getgrid()
{

   $filter = new Array();
$org = $("#txtorg").val();
$org2 = $("#txtorg2").val();

$filter.push({ field: "Orgtable", operator: "eq", value: $org });
$filter.push({ field: "Orgtable", operator: "eq", value: $org2 });
 
 /*   $(document).ready(function () { */
         $("#grid").kendoGrid({
			height: 500,
             dataSource: 
             		{
             				data:parts,
             filter: {
	  	
	  	filters: [
	  				{ field: "PartNumber", operator: "eq", value: $org },
	  				
	  			 ]
	  			 },	
             
		              group: {
		                        field: "Orgtable", aggregates: 
		                        [
		                          { 
		                            field: "Orgtable", aggregate: "count" 
		                          },
		                          { 
		                            field: "Qty", aggregate: "sum" 
		                          }

		                                        
		                        ]
		                     },
		
		             aggregate: [ 
		             				{ field: "Orgtable", aggregate: "count" 
		             				},
		             				{ field: "Qty", aggregate: "sum" 
		             				}

		             			]
                      }, /* end of datasource */

              
             
        columns: [
                            { field: "Orgtable", title: "Orginization", filterable: false, groupHeaderTemplate: "The Org is: #=value# , Qty: #= getSum(value) #" },
                            { field: "PartNumber", title: "Part Number", filterable: false },
							{ field: "Description", title: "Description", filterable: false },
							{ field: "Location", title: "Location" },
							{ field: "Owner", title: "Owner" },
							{ field: "Qty", title: "Qty" , filterable: false }
                            
                        ]   ,  
             
             
          pageable: {input: true, numeric: false},    
        filterable: true,
        sortable: true      
             
             
            
             
          
            
         }); /* end of grid */
       
  /*      var grid2 = $("#grid").data("kendoGrid");
grid2.dataSource.filter($filter); */

      
       
         var grid = $("#grid").data("kendoGrid");
    
grid.collapseGroup(".k-grouping-row:contains(BAE)");
grid.collapseGroup(".k-grouping-row:contains(Army)");
grid.collapseGroup(".k-grouping-row:contains(USMC)");


        
  /*  });  end of document.ready */

 } 


	function getSum(value) {
	
		var datasource = $("#grid").data("kendoGrid").dataSource;
		var result;
		$(datasource.view()).each(function(index, element){
			if(element.value === value) {
				result = element.aggregates.Qty.sum;
			}
		});
		
		return result;
	}
    </script>
