getting the value of colunm related to 80% of counts

[mohamed_ahid]

Hi

see in the attached  sample file , i have loaded an inline table  in which i'm trying to get the value of periode for what the (accumulated count of id agregated by type and month) / (count of id agregated by months and type ) =80% .

the results must be aggregated by months and type .

for exemple 

a  01/01/2015  period 27 because the count if id =5 and  the total count = 6

a 01/02/2015  period 5    because the count if id =6 and  the total count = 7

any idea ?

a	01/01/2015	1	6464	cat1
a	01/01/2015	20	648	cat20
a	01/01/2015	25	96864	cat25
a	01/01/2015	26	4566	cat26
a	01/01/2015	27	6896	cat27
a	01/01/2015	30	469	cat30
a	01/02/2015	4	78689	cat4
a	01/02/2015	25	996	cat25
a	01/02/2015	26	6894	cat26
a	01/02/2015	27	86987	cat27
a	01/02/2015	485	6896	cat485
a	01/02/2015	5	6745	cat5
a	01/02/2015	9	93289	cat9
a	01/03/2015	9	89	cat9
a	01/03/2015	63	63	cat63
a	01/03/2015	6	38896	cat6
a	01/03/2015	9	896	cat9
a	01/03/2015	69	398	cat69
a	01/03/2015	69	8936	cat69
b	01/01/2015	1	6464	cat17
b	01/01/2015	20	648	cat2
b	01/01/2015	25	96864	cat258
b	01/01/2015	26	4566	cat261
b	01/01/2015	27	6896	cat27
b	01/01/2015	30	469	cat308
b	01/02/2015	4	78689	cat46
b	01/02/2015	25	996	cat20
b	01/02/2015	26	6894	cat264
b	01/02/2015	27	86987	cat276
b	01/02/2015	485	6896	cat48
b	01/02/2015	5	6745	cat57
b	01/02/2015	9	93289	cat96
b	01/03/2015	9	89	cat95
b	01/03/2015	63	63	cat635
b	01/03/2015	6	38896	cat63
b	01/03/2015	9	896	cat93
b	01/03/2015	69	398	cat693
b	01/03/2015	69	8936	cat693

Type	Date	period	ID	cat_type
a	01/01/2015	1	6464	cat1
a	01/01/2015	20	648	cat20
a	01/01/2015	25	96864	cat25
a	01/01/2015	26	4566	cat26
a	01/01/2015	27	6896	cat27
a	01/01/2015	30	469	cat30
a	01/02/2015	4	78689	cat4
a	01/02/2015	25	996	cat25
a	01/02/2015	26	6894	cat26
a	01/02/2015	27	86987	cat27
a	01/02/2015	485	6896	cat485
a	01/02/2015	5	6745	cat5
a	01/02/2015	9	93289	cat9
a	01/03/2015	9	89	cat9
a	01/03/2015	63	63	cat63
a	01/03/2015	6	38896	cat6
a	01/03/2015	9	896	cat9
a	01/03/2015	69	398	cat69
a	01/03/2015	69	8936	cat69
b	01/01/2015	1	6464	cat17
b	01/01/2015	20	648	cat2
b	01/01/2015	25	96864	cat258
b	01/01/2015	26	4566	cat261
b	01/01/2015	27	6896	cat27
b	01/01/2015	30	469	cat308
b	01/02/2015	4	78689	cat46
b	01/02/2015	25	996	cat20
b	01/02/2015	26	6894	cat264
b	01/02/2015	27	86987	cat276
b	01/02/2015	485	6896	cat48
b	01/02/2015	5	6745	cat57
b	01/02/2015	9	93289	cat96
b	01/03/2015	9	89	cat95
b	01/03/2015	63	63	cat635
b	01/03/2015	6	38896	cat63
b	01/03/2015	9	896	cat93
b	01/03/2015	69	398	cat693
b	01/03/2015	69	8936	cat693