Hi Folks,
Need your help, I am trying to visualize pie chart with dimension and calculative number. Below is my code but not getting the value and percentage of total value.
CommodityGroup &' : '&
aggr(sum(aggr(only({<Reason={'SHIPPED'},Pcdd_Pull ={'pull-in'}>}FusionPcdd_Pull_Count),FusionPcdd_Pull_Count)),CommodityGroup)
&'; '&
aggr(num(sum(aggr(only({<Reason={'SHIPPED'},Pcdd_Pull ={'pull-in'}>}FusionPcdd_Pull_Count),ComponentPartNumber,SapSoli))
/
sum(Total Aggr(sum(aggr(only({<Reason={'SHIPPED'},Pcdd_Pull ={'pull-in'}>}FusionPcdd_Pull_Count),ComponentPartNumber,SapSoli)),FusionPcdd_Pull_Count)),'#,##0%'),CommodityGroup)
Can team please help me to resolve the calculation.
Kind Regards
Rakesh Kumar