Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have the table as below ("custhist"). I would like to count customers who did 1,2,3,4.... etc transactions, with a variable periodID. In the sample I have 3 periods, but this could be 10 or 13 or 15.
The end result shall be a table like : the filter is PeriodID ( 1301 / 1302 / 1303) >>>> any help very welcome, thanks
numtransactions num customers
1 3
2 2
3 6
4 7
5 3
6 1
.......................................................
n 1
>> doc attached
custhist:
load * inline [
customernr,periodID,numtransactions
1,1301,2
2,1301,1
3,1301,4
4,1301,4
5,1301,5
6,1301,2
1,1302,2
2,1302,3
3,1302,2
4,1302,4
5,1302,6
6,1302,7
1,1303,2
2,1303,8
3,1303,5
4,1303,4
5,1303,3
6,1303,2
];
Sorry, I don't really get what you want to achieve.
Maybe you want to aggregate the transactions per customer in the dimension? Like
=aggr(sum(numtransactions),customernr)
as a calculated dimension?
Sorry, I don't really get what you want to achieve.
Maybe you want to aggregate the transactions per customer in the dimension? Like
=aggr(sum(numtransactions),customernr)
as a calculated dimension?
Hi
thanks, it is exactly what i wanted
need to do this for over 100 million records, i do not know, how it will be, but i will try it