Need to exlude 2nd column in creating a percent of total and running sum measure

Question

Hi My data looks like the screenshot attached. Need to exclude the second column 'not....' from the percentage of total calculations such that the calculations start from Day 0 and computed over the grand totals

Answer 1

If you want to remove the values from the calculations and recalculate the percentages with only the remaining "Day N" columns then right-click on the "Not..." column and select Exclude.

If you simply don't want to see the column and want the current calculations to remain then right-click on the "Not..." column and select Hide. To unhide the column later you can select Reveal Hidden Data from the Analysis menu.