Reputation: 71
Essentially I want to have grand total column like the one I just linked to.
However, I want to hide the column that the grand total is based off of. For example, in reference to the picture, I would want to keep the grand total on the right without displaying the extended price column on the left.
I also tried to write a script that would hide the cells in the On Prepare event of the crosstab, but when I select the crosstab in the script tab it says "This element has no methods".
Is this possible?
Sources:
Stack Overflow question stating to use the onPrepare event
Upvotes: 0
Views: 749
Reputation: 313
Generally, you should be able to do this by selecting the column, and in the property editor below select "Visibility -> Hide Element -> For all outputs".
Upvotes: 1