For Grand Total you Need to go to :" Analysis --> Totals --> Show Column Grand Totals " .
Rest you would need to clarify more , what exactly you are looking for .
I want to show only CC-115 Values in all columns.Can we do that?
You can use IF..ELSE..END statement to get this. I've created three new calc field to link the param.
Let me know If this help.
workbook version 9.3 attached for your reference.
Book1 9.3.twbx 19.9 KB