Pivot table grand total aggregation not working in line chart

[zohebakber]

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]),all([custom manufacturer_sort]))

Now, the default grand total was not giving correct average so I used Average in Total Calculations tab. Hence, I got the correct Grand Total.

The screenshot of pivot is attached for your reference. Hence, 42.3 under Grand total is my desired result.

I want to replicate the same output on the line chart. However, I am unable to do so.
I am using this formula in the Line chart to replicate the same output:

avg([Category],avg([Retailer],(dupcount([Manufacturer])/
(dupcount([Manufacturer]),all([Manufacturer])))))

However, I am getting a different output. See the screenshot of the line chart.

Can anyone please help me creating the correct formula to bring the same output.

Thanks

@Ido_QBeeQ @Helena_qbeeq @harikm007 @pbsisense @Oleg @OlehChudiiovych @Sijo1995 

[Sijo1995]

Hi @zohebakber ,

Please add date in your formula.

Thanks

Sijo

[altvia_support]

Hi @Sijo1995, Not sure if you are able to elaborate any more on your comment? I am trying to achieve a similar result for a pie chart where the 'default total' is not accurate and I would like to display the 'sum grand total' as my value in the pie chart.

Thanks