1 of 1 people found this helpful
Managed to do this (though partially only) with Table Calculations. Below is the definition I used
IF FIRST()==0 THEN
Placed the lowest level (ie Product ) in the detail shelf and change compute using to Product.
This worked when we roll up/down at Category and Subcategory levels but when down to Product it still gives the aggregated value.
So only a partial solution