topic Re: adding column in pivot table in QlikView

adding column in pivot table

Fri, 13 Nov 2015 07:08:32 GMT

Hi Friends,

i would like to add a column name as total sales in the below given table with respect to year and Business unit wise,

so can any one suggest me how can i do this?

Anonymous — Fri, 13 Nov 2015 07:15:20 GMT

Add one more expression say Total Sales in exprssion properties:

like:

Total Sales=sum(Central Ops Expression)+Sum(OFS Expression)+sum(PE)+sum(TI)

PrashantSangle — Fri, 13 Nov 2015 07:17:39 GMT

Hi,

Select Partial Sum from chart Property->Presentation tab

Regards

tamilarasu — Fri, 13 Nov 2015 07:22:28 GMT

Goto presentation tab and enable partial sum for Business Unit dimension

Fri, 13 Nov 2015 07:24:20 GMT

Hi,

Thank you for the reply,

if i select the Partial sum as you said, it is showing at the top or bottom, but i want to show it at the last (right side).

any idea about it?

Fri, 13 Nov 2015 07:31:21 GMT

Thanks a lot Tamil