Someone shared with me that it is possible, but provided my category column referring to the field which has the separate value, for the categorization.
Thus, if I put a formula, such as Category1:“Category2”, in one of the column, would it be displayed twice? Whereby Category2 was hardcoded later.
IN this view, I want it to show total cost by product on top of the view, at the bottom, it will display average cost per product.
Or this is overkill? might as well just come out with a script to excel?