Hi All,
Need your expert help:
I have two data sheets
1) Rawdata for orders recieved
2) Rawdata for escalations
Orders recieved has the created date, closed date.
Escalations has the escalation date, close date
I can get the same month closed count for both sheets....
I am creating relationship between the tables to get the data in one single pivot table but the counts are way off when i try to create the table with created month or closed month....
What I am trying to achieve is a single pivot table which can show by created month total created orders ; total orders closed same month; total closed ; total escalated ; total escalated closed same month ; total escalated closed....
So for example for July-22 :
Total created could be 1000
Same month closed could be 800
Total closed could be 1250 (as previous month pending orders may have been closed)
Total escalated could be 100
Same month escalated closed could be 80
Total escalations closed could be 130
Is this possible...
Thank you
Need your expert help:
I have two data sheets
1) Rawdata for orders recieved
2) Rawdata for escalations
Orders recieved has the created date, closed date.
Escalations has the escalation date, close date
I can get the same month closed count for both sheets....
I am creating relationship between the tables to get the data in one single pivot table but the counts are way off when i try to create the table with created month or closed month....
What I am trying to achieve is a single pivot table which can show by created month total created orders ; total orders closed same month; total closed ; total escalated ; total escalated closed same month ; total escalated closed....
So for example for July-22 :
Total created could be 1000
Same month closed could be 800
Total closed could be 1250 (as previous month pending orders may have been closed)
Total escalated could be 100
Same month escalated closed could be 80
Total escalations closed could be 130
Is this possible...
Thank you