how do i calculate Percentage

[#1]

Dear Sir,

Plz help me to count percentage of my  below file.  if i  select field of  response time  i.e 3 days ,it  show me in % out of total  response time by months wise.  

Monthwise	Response time	Status
JAN	0	Processing
JAN	0	Processing
JAN	3 Days	Justified
JAN	7 Days	Justified
JAN	3 Days	Justified
JAN	3 Days	Unjustified
JAN	25 Days	Unjustified
JAN	25 +Days	Justified
JAN	3 Days	Justified
JAN	3 Days	Justified
JAN	3 Days	Unjustified
JAN	0	Processing
FEB	15 Days	Justified
FEB	3 Days	Unjustified
FEB	3 Days	Unjustified
FEB	15 Days	Unjustified
FEB	3 Days	Unjustified
FEB	3 Days	Justified
FEB	3 Days	Justifie

[Gysbert_Wassenaar]

Use monthwise as dimension and this expression: count({<[Response time]={'3 Days'}>}Status)/count( total <Monthwise> Status)

See attached qvw.

[#3]

Hi  Gysbert,

Thanks for your quick response.

I have done the job  explain by you, but I am  not getting result which I need.

[Gysbert_Wassenaar]

I misunderstood your question. Try count(Status)/count({<[Response time]=>} total <Monthwise> Status)

[#5]

Ok,I will check   and let u know.

[#6]

yes, it  is working,

however if  I wish to not count '' processing'' in total , then what is formula.

[Gysbert_Wassenaar]

In this case this will do:

count(Status)/count({<[Response time]=-{0}>} total <Monthwise> Status)

This will work to specifically exclude status Processing, even if response time were not 0:

count({<Status-={'Processing'}>}Status)/count({<[Response time]=,Status-={'Processing'}>} total <Monthwise> Status)

[#8]

thank you , I will check and update to you.

I have query about  sheet .

how do I prevent  field and object   values   is not change while change of   sheet. or  in other way  no change of field and object  in case of change a sheet.