Total Freeze in Pivot

[vijayit43]

Dear All,

We Want To freeze Total On Top Or Bottom In Pivot When Scrolling Vertical. Its Possible

[Gysbert_Wassenaar]

Not in the pivot table. You could try using text boxes to display the total above or below the pivot chart. Or use an expression for the label of the expression that shows the total (in combination with a label text): ='Sales ' & num(sum(Sales),'#,##0')

[vijayit43]

Dear Gysbert,

Are You Provide Any Sample For this?

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[vijayit43]

Thanks,

Its Solve My Problem