I've been trying to research this over the last couple days without any luck. I've attached an Excel file to illustrate what I am trying to accomplish via Qlik.
I am trying to create a dimension within my model for Deal Size Bands, i.e >$1M, $500k-$1M, $250k-$500k, etc. Unfortunately, this is challenging because the revenue data I am working with can have one deal spread across multiple rows. As a result, I basically need to create deal band buckets based on the distinct sum of a given row.
Any help would be greatly appreciated!