topic Re: Add Column on a Pivot Table in QlikView

Add Column on a Pivot Table

Fri, 15 Jan 2016 20:48:00 GMT

Hi People:

I have a pivot table with 3 dimenssions CC, PE, Item, Period, and 1 expression (sum(amount)) and this work perfect.

Now I have to add a "T1" column, which is the sum of all period by row, regardless of the period they are.

Is possibel?

Regards

Please see the example on excel

Re: Add Column on a Pivot Table

Fri, 15 Jan 2016 21:20:20 GMT

Use the Partial sum option on Presentation tab and it creates new column that holds sum of all periods data.

Re: Add Column on a Pivot Table

Fri, 15 Jan 2016 21:28:53 GMT

great idea! and it works, I already had subtotals at botton, as I do to make that column total first?

Thanks Regards!

Re: Add Column on a Pivot Table

Fri, 15 Jan 2016 21:30:41 GMT

On the Presentation Tab, select "Item" and check on Show Partial Sum. You can move the Total column to the end as last column after period or first column by selecting Subtotals on Top/ Subtotals on Bottom on the same tab.

Re: Add Column on a Pivot Table

Fri, 15 Jan 2016 21:40:23 GMT

There is option show Total Top or Bottom and Select Top option.

Re: Add Column on a Pivot Table

Fri, 15 Jan 2016 21:41:26 GMT

Hi Tripti, if u see the excel i have anothers subtotal, and if i change but all de subtotal change of position at top or botton, all subtotals change the position, is possibel change only for the column of total?

Thanks Regards

Re: Add Column on a Pivot Table

Peter_Cammaert — Sat, 16 Jan 2016 12:00:30 GMT

No. The standard QV option relocates all (sub)totals together.

You can however create your own subtotals. Lots of work and not much of pivot flexibility left.

Peter