Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

techvarun
Valued Contributor II

Pivot Table Total

I have a pivot table as attached image. in that pivot table i need to show the sum of mark1,mark2,mark3,mark4,mark5

Both rowwise and columnwise


Thanks in advance

Regards

5 Replies

Re: Pivot Table Total

Hi,

     Go to Properties -> Presentation -> Click on the dimension and check Partial sum

Regards,

Kaushik Solanki

techvarun
Valued Contributor II

Re: Pivot Table Total

am able to get totals on expression column but not in mark1 ,mark2,....... column


Regards

Re: Pivot Table Total

Hi,

     Do you have the seperate expression for each mark?

Regards,

Kaushik Solanki    

techvarun
Valued Contributor II

Re: Pivot Table Total

No Kaushik Solanki all the marks columns are directly from table

techvarun
Valued Contributor II

Re: Pivot Table Total

Hi Kaushik Solanki


Thanks you

I have changed all the Dimentions to expressions and now it is working fine

Thanks & Regards

Community Browser