harshilbhatt_16

Hi all my goal is to get the below results in jaspersoft. Sum of total_line_price start_date_fiscal_year contract_numstart_dateitem_numberitem_descriptionline_statussales_order_numpurchase_orderbill_to_ucn2016201713003091/11/2016569910SCHOLASTIC MINIBOOKS 1 YEAR SUBSCRIPTION 29.99EXPIRED 29.99 26873761/11/2017569910SCHOLASTIC MINIBOOKS 1 YEAR SUBSCRIPTION 29.99ACTIVE46266966 622176741 29.99Grand Total 29.9929.99 The results that i am getting are not right with the totals. So i created a report without any totals. but they how do i get the grand total to be different for 2016 and 2017 ? Below are the steps i am following