Hi All,

Tue, 17 Mar 2015 17:31:34 GMT

i have developed one QVW Application with Pivot table showing total for each column. Now i also want to show average and percentage below that.

Attaching screen shot for .......please open attached file in paint reference.

Re: Hi All,

JonnyPoole — Tue, 17 Mar 2015 17:47:47 GMT

This might work. ( my own sample)

I increased the line height to 3 and made a custom totals header and a custom totals expression:

Sales Expression:

if( Dimensionality()>0, sum(Sales),

sum(Sales) & chr(10) & avg( Sales) & chr(10) & num(sum(Sales) / sum(total Sales),'#,##0%'))

Totals Expression: