Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Can anyone please help me for my below requirement.
I have attached the data sheet where I have a date field, Jobno and status column.
I need a pivot table where I can see the frequency and count of jobs repeated by status. E.g.
2 jobs has been repeated 5 times for so and so status.
This is the example done in the excel sheet. ( Count will be different as data and below statistics are for different month)
Repeated and Unique Orders | |||||
Times Repeated | Unique Orders | Total Orders | Status | ||
Completed | M-CUST | M-STC | |||
6 | 1 | 6 | 0 | 3 | 3 |
5 | 2 | 10 | 2 | 3 | 5 |
4 | 9 | 36 | 3 | 16 | 17 |
3 | 35 | 105 | 19 | 45 | 41 |
2 | 218 | 436 | 105 | 141 | 190 |
1 | 1591 | 1591 | 860 | 194 | 537 |
Total | 1856 | 2184 | 989 | 402 | 793 |
Repeated Percentage | 27% |
This?
Straight table with
Dimension:
=Aggr(Count(JOBNO), JOBNO)
Expressions
=Count(DISTINCT JOBNO)
=Count(JOBNO)
=Count({<Status = {'Completed'}>}JOBNO)
=Count({<Status = {'M-CUST'}>}JOBNO)
=Count({<Status = {'M-STC'}>}JOBNO)