Percent of total in grand total row

Sbhatia
Sbhatia Member
in Cards, Dashboards, Stories

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

image.png
Tagged:

Best Answer

  • ggenovese
    ggenovese Coach
    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 Coach
    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)

  • Sbhatia
    Sbhatia Member

    thanks so much - that worked!

Categories