I need your help to understand how I can calculate % share based on sub-total value.
I am currently using AGGR(SUM(QUANTITY),FULL_OR_EMPTY) and by doing so I am able to get sub-total for 1 row item instead of all the row items under group "FULL_OR_EMPTY"
Your help to extend this sub-total to all the row items is needed.