topic Change Straight Table Total Mode in QlikView https://community.qlik.com/t5/QlikView/Change-Straight-Table-Total-Mode/m-p/184735#M49485 <HTML><HEAD></HEAD><BODY><P>Hi, I am wondering if it's possible to customize the total mode calculation to something other than the functions that the total mode in chart properties provide.</P><P>I am hoping to produce a simple straight table with a calculated row on the bottom. The calculation would add/subtract different line items to get the desired result.</P><P>The dimension for the table is "Report_Items" and some line items include: Revenue, Direct Expense, Indirect Expense. To make this example simple, I just want the bottom row to calculate Profitability as Revenue minus Direct Expense minus Indirect Expense.</P><P>Any suggestion to the total mode customization or other approaches?</P><P>Thanks.</P></BODY></HTML> Tue, 25 Jan 2011 21:15:26 GMT 2011-01-25T21:15:26Z Change Straight Table Total Mode https://community.qlik.com/t5/QlikView/Change-Straight-Table-Total-Mode/m-p/184735#M49485 <HTML><HEAD></HEAD><BODY><P>Hi, I am wondering if it's possible to customize the total mode calculation to something other than the functions that the total mode in chart properties provide.</P><P>I am hoping to produce a simple straight table with a calculated row on the bottom. The calculation would add/subtract different line items to get the desired result.</P><P>The dimension for the table is "Report_Items" and some line items include: Revenue, Direct Expense, Indirect Expense. To make this example simple, I just want the bottom row to calculate Profitability as Revenue minus Direct Expense minus Indirect Expense.</P><P>Any suggestion to the total mode customization or other approaches?</P><P>Thanks.</P></BODY></HTML> Tue, 25 Jan 2011 21:15:26 GMT https://community.qlik.com/t5/QlikView/Change-Straight-Table-Total-Mode/m-p/184735#M49485 2011-01-25T21:15:26Z