1 of 1 people found this helpful
Hi Kiran K
I found this page pretty handy when it comes to Grands Totals: Customizing Grand Totals – Part 3 | Drawing with Numbers
I'm sure it could help you out!
Let me know
Use TOTAL(COUNTD([some field])) instead of SIZE() - though it may create some performance issues since TOTAL() will trigger a separate query. There are alternatives to using TOTAL(COUNTD()) but they would take more work and require knowing more about what you are trying to do.
Also, the calc as written will fail if there are exactly 9 columns or exactly 7 rows, or both.