you could try reshaping the dataset using a cartesian join - create a copy of the data set and join with condition that 1=1
see the attached
this is the result
or as a single value
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
cat example.twbx 17.4 KB
Thank you, I'm much closer to a solution. Unfortunately the data set I have is too big to duplicate as Jim said, and I cannot share it to show you.
The problem with your solution was that it gave me only the min of Values from that Account number. I should've added that each Account has several values and it's the sum I'd like.