Hi guys,
i've a big problem and i don't know how to solve it.
I'll try to describe the problem :
I've a database with a tree milions of record and i need to create a pivot table group by a data and apply a count of records(it's seem to be easy till now....)
the count should be only on 80% of records for each data showed on pivot table(something like top percent in sql but grouped by data), i.e. :
data id
01/01/2013 100
01/01/2013 101
01/01/2013 102
01/01/2013 103
02/01/2013 104
02/01/2013 105
02/01/2013 106
03/01/2013 107
03/01/2013 108
03/01/2013 109
03/01/2013 110
03/01/2013 111
03/01/2013 112
03/01/2013 113
03/01/2013 114
03/01/2013 115
03/01/2013 116
the pivot should be :
01/01/2013 3
02/01/2013 2
03/01/2013 8
I hope it's clear.
pls help me.
thx a lot.
bye.