Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
i have some requirement its about calculate email instances based on products there are two scenarios
scenario1: in store i have 5 products i want know which user was buying his first purchase in which product i need to calculate based on the email id and parallelly what is second purchase like this
Products | 1 | 2 | 3 | 4 | 5 |
Product1 | 8 | 1 | 1 | 1 | 1 |
Product2 | 12 | 2 | - | - | - |
Product3 | 17 | 4 | 3 | 3 | 2 |
Product4 | 8 | 2 | - | - | - |
Product5 | 8 | 2 | - | - | - |
the required user want to know how many purchased product1 for the first ,second,third,....etc i achieved partially the above issue by using autonumber but still missing for s,iome instances
Another sccerio2 is very tricky , the user want to know the customers who bought product 1 want to know remaining transactions whether they bought same product again or something else or didn't buy remaining products followed by remaining products
i can't provide samll output for the second scenario 2 it was very difficult for me to create still any doubts can ping me
Regards
Saradhi
How you are getting 50 ??
anil
as i mentioned in the post don't compare the your output with my output file i just added some random numbers its very difficult to calculate these requirement in the excel just see the output format only not numbers
At least, We need to know the logic behind. Let me explain here if you want to show who purchase first then expression should be this
Only({<Date = {'$(=Min(Date))'}>}Email)
But, When we talk about number at least some logic need to work on it?
I know, This is not make sense because i simply run up with Random values
HI anil
i attached sample output