Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Gurus,
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.
Thanks & regards,
Aadil
Hi,
I was able to resolve this by following code SUM(TOTAL <FULL_OR_EMPTY>QUANTITY)
Thanks & regards,
Aadil