Pivot table grand total aggregation not working in line chart

Hi Team, I have calculated the manufacture share on pivot table at two levels ( Retailer and Category) using the formula: dupcount([custom manufacturer_sort])/ (dupcount([custom manufacturer_sort]...