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.

[ashfaq_haseeb]

Hi,

may be like this.

Regards

ASHFAQ

[#3]

Hi Ashfaq,

   Thanks for your it is working now but how to add this percentage at the bottom also.

       Application,User Training,etc etc ...

ex.  7/27 %        ,4/27     

[mahesh_agrawal]

Hi Nishika,

Just go to the Chart's properties.

Select the Grand Total expression in expression tab,then check the "Relative"  check box for the GRAND Total expression.

[ashfaq_haseeb]

Hi,

May be like this.

Regards

ASHFAQ

[#6]

Hi,

I need  row at the bottom for % .Please find the attached screen shot.

[ashfaq_haseeb · Accepted solution]

Hi,

One of the work around could be like this.

Regards

ASHFAQ

[#8]

hi,

this is how you can do it. if u want i can attach QVw.

regards

harshal sonone

[#9]

Hi,

Thanks for the reply.

Please attach the Qvw file and can i add  separate row for percentage at the bottom in the table option of the chart properties .You are showing it as a row i just want is the total % only to be shown at the row of each product line.For eg.15% should come at the bottom of 4.

         App Config,   Application etc etc ...

Total     4               ,  7

   %     15%          ,  26%

[ashfaq_haseeb]

Hi,

did you look at my solution status1.3.qvw

Regards

ASHFAQ

[#11]

HI nishika

PFA qvw.