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

Tagged:

Best Answer

  • ggenovese
    ggenovese Contributor
    Answer ✓

    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)

Answers

  • ggenovese
    ggenovese Contributor
    Answer ✓

    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!