I am trying to get the % of each product quantity against the total quantity using parentgroupval formula. I am unable to get find the quantity grand total thus all % is showing 100%.
This is the formula i used.
QUANTITY:SUM/PARENTGROUPVAL(QUANTITY:SUM,PRODUCT_NAME, Opportunity.Country_Importer__c)
What is need is, 1500/2898 = 51.75% and 198/2898 =6.83%
Appreciate your help!
8 réponses
