What set analysis to be use in getting grand total reflects as new column?

[kristeljoymalapitan]

Good Day,

Please help me on what set analysis/functions to be use on  below sample data

 I need to add new column 'Total' on the right side and 'Grand total' at the bottom. (highlighted on red font)

Total = total count of accounts per ROLLRATES and per BUCKET .

Please refer to sample output and raw data for your reference

Hope to hear you the soonest.

Thank you

[pradosh_thakur · Accepted solution]

Please close the thread if answered.

[kristeljoymalapitan]

I can't find position 'top' under my apperance menu.

[pradosh_thakur · Accepted solution]

I am using a simple table and not the pivot table.

[kristeljoymalapitan]

Got it! Thanks 🙂