3 Replies Latest reply: Sep 9, 2011 4:33 PM by Brad House RSS

    Calculate Percent of Total?

      I've got a straight table where I'm trying to calculate the percent of the total an expression.

       

       

      Example Data

      Group   Value

      HH       100

      BB       200

      CC     700

      Total   1000

       

       

      Straight Table Should Look like:

       

      Group   %

      HH       10%

      BB       20%

      CC       70%

       

      I've tried a few thing and nothing works.

       

      I'm new to QV and any help would be appreciated.

       

      Thanks!