Hi All,
In the attached extract cells highlighted in green are the input data and grey highlighted are the required output. In excel I apply if formula to get the client name i.e X1 in the column A and they I apply subtotal to the get the total amount for each client.
Since I am a newbie to alteryx I am unable to get the required output. It would be very helpful if anyone can suggest solution.
Many Thanks,
Usman
Solved! Go to Solution.
@Usman_Ahmad
Maybe something like this?
Thank you so much. This solves my problem.
@Usman_Ahmad
Glad to help and thank you also for the accept mark.