How to count number of transactions with different entry dates

[mahnoor1279]

Hello everyone

I've this table with the columns details as

Now i want to show the transactions group by the users in a table ,

but the total of both tables is changed , and when i delete the column of 'DATE'  then this will work fine 

using the below expression 

Count({<ENTER_DATE_RED,CNIC, TRANS_TYPE={'REDEMPTION'}>}DISTINCT TRANSACTION_SNO)

[snibrahim1993]

Hi @mahnoor1279  I think it counts including the same Transaction numbers