Hi @sami.rubenfeld, thanks for getting back to me. I'm happy to chat with support directly, however I've seen a few threads of similar requests get resolved this way and the solution not get posted for others (like me!) to see.
At a simplified level, I have my data table with 4 columns: two dimensions, one calculated field, and one measure. I've used fruit for the sake of this example:
I can't calculate the field without having both the dimensions in the data table, however I don't need them in my visualization. So if I hide those, I want the visualization to group by each included category and sum the inventory, for three concise numbers instead of a line for every row.