topic Pivot table grand total presentation in QlikView

Pivot table grand total presentation

Wed, 04 Jun 2014 10:08:17 GMT

Help. I

Help. I have a Pivot chart table.

How do you add lines above and below the Grand total cell.

thanks Sian

have a Pivot chart table.

How do you add lines above and below the Grand total cell.

thanks Sian

Re: Pivot table grand total presentation

Anonymous — Wed, 04 Jun 2014 10:10:52 GMT

Why do you want to add line after Grand Total.

Please elaborate your requirement more.

Also if possible, post a sample app.

Regards

Nitin

Re: Pivot table grand total presentation

Wed, 04 Jun 2014 13:17:56 GMT

Hi Nitin.

Thanks for the reply. This is the table below as you can see the cost has a border in the grandtotal row and Number column doesn’t. I have no idea how I managed to do this and would like borders on both columns.

Re: Pivot table grand total presentation

Wed, 04 Jun 2014 13:25:13 GMT

Hi Sian,

Select Grid Design (ctrl-G) and Right Click on Chart ---> Custom Format Cell and Choose Cell Border.

Hope this helps.

Sridhar