Display aggr sum totals in a table

[Anonymous]

How do i display the sum totals in a table perferably pivot table because th expression works but the sum totals is blank.

"aggr(max([m_Sum Assured]),[Policy Number])"

Thanks

Kwame

[Gysbert_Wassenaar]

Perhaps sum(aggr(max([m_Sum Assured]),[Policy Number])).

If that doesn't help please post an example document that explains what you need. In that case maybe you should read this document: Preparing examples for Upload - Reduction and Data Scrambling