How to add column in pivot table

[#1]

I need add  a column after 02, named (total actual, total budget, total gap) to show total number of Actual (actual01+actual02) , total number of Budget (Budget01+Budget02) and total number of Gap (Gap01+Gap02)

How can i come true this? Thanks.

[simondachstr]

I recommend you rather use the table chart and specify 9 expressions or use the SmartReporting extension found on branch.qlik.com

http://branch.qlik.com/projects/showthread.php?609-SmartReporting&highlight=smart

[karthikeyan1504]

Hi,

There is no feature in qlik sense to add the total column at right most.

You can create two more expressions but it will show near 01 & 02.

[reddy-s]

Hi Batter,

The only way to create this is to add an other dimension value to the the set of 01,02 and totals(new field) and this new field total displays 3 other colums like the total actuals, total budget and total gap which are based on the calculations you needed.

Or go with a custom visualization which provides the totals row wise.

[JonnyPoole · Accepted solution]

You can add an extra field to your data model for the dimension (Group Name?) whose data values are on the top showing 01 , 02 etc... as dimension values.

Open the data load editor and do something like the following to create the new field:

//this will associate all groups with themselves.

Table:

Load

     [Group Name],

     [Group Name] as [Group Name with Totals]

resident <>

//this will ALSO associate all groups with a new value called Total. So the measures will show totals for all values

concatenate (Table)

Load

     [Group Name],

     'Total' as [Group Name with Totals]

resident <>

Then add [Group Name with Totals] to the chart to replace Group Name.

It should open up a new column.

[#6]

Thanks very much, it works. But when I change the select of the month the total value will not change, right?

[JonnyPoole]

The total (like everything else) should be filtered down to whatever current selections you have

[#8]

Got it. Thanks. It changes now then I selected some months.