How to calculate % in the table of chart properties.

[#1]

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.

[#2]

yes i do in status 1.3 but in that you are calculating each row but i want is

7/27  (27 is the grand total sum) then for App Config  4/27  same for all the columns .

A separate row should be added at the bottom

[ashfaq_haseeb]

Hi,

I did the same.

I prefer you to go through 1.3 once.

Look at the image attached.

The one you posted is for 1.2

Regards

ASHFAQ

[#4]

hi Ashfaq,

    Thank you soo much i got it .

[#5]

Hi Harshal,

  Thank soo much .