Change count number to percentage

[yashcena]

I have a pivot table which shows the count of different ‘States’ of a defect. It looks something like this:

Instead of showing the numbers for each of the states, I want to show the percentage.

Currently I’m using the following expression:

count({$<DefState ={*}- {'Closed'}>}DefectID)

(I don’t have to show the defects which are closed)

I think the option to show the expression relatively is not available in pivot chart.

Can this be done? I hope I have made the requirement clear.

Thanks,

YASH

[MK_QSL]

count({$<DefState ={*}- {'Closed'}>}DefectID)/count(Total{$<DefState ={*}- {'Closed'}>}DefectID)

[prat1507]

Maybe this

Store the value in a variable as

var1=count({$<DefState ={*}- {'Closed'},>}DefectID)

and use in expression as

count({$<DefState ={*}- {'Closed'}>}DefectID)/$(var1)

Use NUM to show as percentage.

Regards

Pratyush

[sunny_talwar]

May be this

Count({$<DefState ={*}- {'Closed'}>}DefectID)/Count(TOTAL <Severity, State>{$<DefState ={*}- {'Closed'}>}DefectID)

or

Count({$<DefState ={*}- {'Closed'}>}DefectID)/Count(TOTAL <State>{$<DefState ={*}- {'Closed'}>}DefectID)

[prma7799]

May be like this??

=(count({$<DefState -={'Closed'}>}DefectID) / count(TOTAL{$<DefState -={'Closed'}>}DefectID)) *100