I have two columns, Sum of Kids and Sum of Class Rooms, I would like to take the Sum of Classes/Sum of Kids and display as a new value for the year and quarter. From all the documentation I've read I can't seem to figure this out. I've tried making a calculated column but the values don't turn out properly.
Year # Kids # Classes 2018 236 128 54%
1	        	71	47			  	66%
    1         	26	15				
    2       	15	10			
    3       	30	22				
2	        	69	36			  	52%
    4       	40	21				
    5       	20	10				
    6       	9	5				
->pipe(new Pivot(array(
        'dimensions'=>array(
            'row'=>'year,case_dt, month',
        ),
        'aggregates'=>array(
            'count'=>'case_dt',
            'sum'=> 'kids, class,
        )
    )))