Percent of total in grand total row

How can I have the percent of total for the grand total rather than the sum of the WoW column? e.g. (mktg visits - lw sessions) / lw sessions in to the total row

Find more posts tagged with

Beast Mode

Accepted answers

If your WoW beast mode is:

(mktg visits - lw sessions) / lw sessions

then change it to:

(SUM (mktg visits) - SUM(lw sessions)) / SUM(lw sessions)

All comments

If your WoW beast mode is:

(mktg visits - lw sessions) / lw sessions

then change it to:

(SUM (mktg visits) - SUM(lw sessions)) / SUM(lw sessions)

thanks so much - that worked!

Quick Links