23 Replies Latest reply: May 28, 2014 12:54 AM by Nishika Tamta RSS

    How to calculate % in the table of chart properties.

      I am trying to calculate the percentage ,i am not able to sum the values of the Grand total because it is the expression in the chart option.The expression for grand total is: count({<CategoryDefect={'Application','User Training','Environment','App Config','Scope Change','Duplicate'}>}CategoryDefect).The Grand Total value is not static value it will change according to the selection of product line.

       

      I have uploaded the excel sheet of the table that i want to be displayed  .

       

      Thanks.