Creating analysis issue.

3245399

Hi Experts,

I have a table has 2 columns:

CUS_ID  #_OF_TXN.

id_1         1

id_2         2

.......

I want to create a report as below:

TXN_SEGMENT     NO_OF_CUSTOMERS (Count distinct CUS_ID)

1 TXN                     x

2 TXN                     y

>2 TXN                   z

i can not use PIVOT table here since the data has millions of records and always throw error: exceeded maximum allowed (though i have change the config in instanceconfig.xml to allow millions of records).

Please help me to create this report without the use of PIVOT table,

Thank you!