Frequency for repeated numbers

[malimohammed]

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%

[sunny_talwar]

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)