5 Replies Latest reply: Aug 25, 2011 2:48 PM by Stefan Wühl RSS

    Calculate a % of total by group in a stacked bar

      Hi, does anyone know how to create a stacked bar by showing the % of total in each subgroup?  I tried writing this expression but it isn't working for me

       

      sum([TOTAL REVENUE ($)])/Sum(total<[TOTAL REVENUE ($)]>[Subgroup])

       

      Thanks!

       

      I'm strugging in that it's creating a % of the entire selection not by quarter and breaking it out