pivot table

[nareshthavidishetty]

Hi all,

i want to display grand total on total in the pivot table i know there is no possibility of total mode in expr tab

is there any other option can any one tell me

[tresesco]

Perhaps there is. Try to share a sample qvw explaining your expected output.

[Anonymous]

Pivot Table -> Properties ->Presentation -> Select Dimension from Top Left -> Check Show Partial Sum

[nareshthavidishetty]

Hi Balraj, i  dont need partial sums i need grand total on the totals

looking for row wise

[Anonymous]

Well, as Tresesco asked, share a samle QVW

[tresesco]

Try using aggr(), like:

=Sum(Aggr(Avg(Value),Dim))

Now, if you enable partial sum, you get sum-of-rows in total.

[nareshthavidishetty]

thanks treseco i vll try and let u know