Hey @tzachi ,
you could use that column as a group by level within a LAC Using level-aware calculations in Amazon QuickSight - Amazon QuickSight
There is also a great article from @David_Wong
Level-Aware Calculations: Tips and Best Practices - Learning Center / Articles - Amazon QuickSight Community
Or do you want to use that column differently? If this doesn’t help you maybe you could provide some screenshots.
BR
Robert