Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

Pivot table to ignore the Total for some rows and Total column should appear on the right side

I am new to Qlik Sense and I am really struggling with my issue. I have a pivot table with 1 calculated Dimension (Last 12 Months) and 3 Measures as Rows. (DVA, NAV and Absolute Performance). 

1. I don't want to show the total of NAV but the total of DVA and Absolute Performance should be visible 
2. I want the total should be on the right side of my table


Pivot Table.JPG

My Dimension is also calculated is Date is 

= Date(If(date >= AddMonths(selectedDate , -11) and date <= selectedDate, date), 'MMM-YY') 

where selectedDate is an island date which the user selecting from a dropdown. 

Please help!!!!