Forum Discussion

zohebakber's avatar
zohebakber
Cloud Apps
07-28-2023

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]),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 Adva_Dadush Oleg OlehChudiiovych Sijo1995 

 

 

 

 

 



Code-first Analytics
dashboards & reporting
Data Models

2 Replies

Replies have been turned off for this discussion
  • altvia_support's avatar
    altvia_support
    Cloud Apps
    11-17-2023

    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