cancel
Showing results for 
Search instead for 
Did you mean: 

Pivot table grand total aggregation not working in line chart

zohebakber
9 - Travel Pro
9 - Travel Pro

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 

 

zohebakber_3-1690534935918.png

 

 

 

zohebakber_0-1690534697952.png

zohebakber_1-1690534744674.png

 



2 REPLIES 2

Sijo1995
9 - Travel Pro
9 - Travel Pro

Hi @zohebakber ,

Please add date in your formula.

 

Thanks

Sijo

altvia_support
8 - Cloud Apps
8 - Cloud Apps

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