Hi Concern,
Please help me to get unique customer id with Date and Amount.
For instance, Total 45376 records in the sheet. I have got the below first 3 columns from Pivot.
Now i need Unique Numbers column based on Amount and Date.
tried manually calculated from Pivot unique CustomerID for 15th Nov with 90 Amount is 4844 same as 135 amount will follow 523 unique numbers.
How to find the easiest way to calculate all in one shot.
Date Amount Total_Nos Unique_Numbers
15/11/2018 90 6,668.00 4,844.00
15/11/2018 135 889.00 523.00
15/11/2018 225 13,969.00 ?
15/11/2018 450 3,450.00 ?
15/11/2018 900 35.00
15/11/2018 2250 3.00
16/11/2018 90 5,197.00
16/11/2018 135 638.00
16/11/2018 225 11,825.00
16/11/2018 450 2,653.00
16/11/2018 900 42.00
16/11/2018 2250 7.00
Attached sheet for your reference
Thanks,
Siva
Bookmarks