Monthly Percentage of Complain

[Waqar]

Hi

I have a sheet where i record daily complains, I want monthly percentage of completed and pending complain.

There are four category of complain 1.Minor1 2.Minor2 3.Major1 4.Major2 (Last Column of the Sheet)

*Minor1 Complain which complete without financial expense within 4 days.
*Minor2 Complain which complete without financial expense more then 4 days.
*Mojor1 Complain which complete with financial expense within 10 days.
*Mojor2 Complain which complete with financial expense more then 10 days.

I want a solution so that i can find out monthly ratio of Minor1 Minor 2 Major1 Major2
example:: in Jan 2012 60% of Minor1 complain completed. :: in Feb 86% Major2 complain completed.

Regards

 

[JavierGuillen]

Can you post a more representative sample of your data? (not just the last column of the sheet)

 

[Waqar]

Thanks JavierGuillen

Sure why not. Can i attach a sample sheet on this forum? for more understanding.
How? guide me, i unable to find way.
Regards

 

[JavierGuillen]

Do you have a skydrive account? you can upload it there and share the link

 

[Waqar]

Thanks JavierGuillen
No i dont have.
Colomns detail are here
1.Complain Date 2.Complain Detail 3.Complain completed in days 4.Expenditure 5.Approved by 6.Complain 7.Remarks(Minor Major etc)

is it enough?
Regards

 

[Waqar]

Hi JavierGuillen
Should i elaborate more or u got my point of view

REgards

 

[JavierGuillen]

Yes, please elaborate more. It is makes it easier to know a subset of each of the tables involved, in order better understand your set up

 

[Waqar]

Thanks JavierGuillen

I working in IT Dept My work is to record daily complain and report it to ISO department.
the requirement of of ISO Dept is analysis data in four category.(all in percentage)
How many Minor complains are completed within 4 days in each month (Minor 1)
How many Minor Complains are taken more then 4 days in each month (Minor 2)
How many Major complains are completed within 10 days in each month (Major1)
How many Major complains are completed in more then 10 days in each month (Major2)
The Difference in minor and major is financial approval. The complain which can not be complete without money are called Major.

1.Complain Date 2.Complain Detail 3.Complain completed in days 4.Expenditure 5.Approved by 6.Complain 7.Remarks(Minor Major etc)

So Colomn No 4 decide weather it is Minor or Major.
I try to make via Pivot table but fail to get correct result.

is it elaborate or u need more?
Regards

 

[Waqar]

Hi JavierGuillen

Am i able to convey my point of view to you?

Regards

 

[JavierGuillen]

It may make it easier if you post a 'sample' of what your data looks like. Not just the column names, but some 'fake' data as well, covering all the scenarios you want to cover in your calculation.