Hi All,

[#1]

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.

[JonnyPoole]

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: