Go to analysis --> Total --> Show Column Grad Totals you will get the required O/P
You will get a view like below with total
If you want to rename the grand total to national
follow the below steps
Click on Grand total format
Hope this helps plz mark this answer as correct or helpful to close the thread
But I'm not looking for Grand total, assume I need sum of A & B only
Here It is
You need to Self Union your data and Write One Calc as Shown to get it. You can Take out Tablename from Rows it is Just for Illustrating
If it Helps, Pl mark it Helpful and CORRECT to Close Thread
Add Dimension Value.twbx 12.5 KB
Thanks for your reply, can you please attached file.
I already attached the file. Please go to your Thread. Files are not Visible in email.