When I performing Show Row grand total option I am getting zero.
but I calculating Column Grand Total getting value.
how we perform grand total.
please go to menu and select Analysis > Totals > Show row grand totals
repeat the above step for column grand totals.
if the above scenario didn't work for you, please provide some sample workbook.
If your grand total is not working then go through this doc where Jonathan Sir has explained the reasons brilliantly.
Why Your Grand Total or Subtotal Isn't Working as Expected
Retrieving data ...