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]...
Code-first Analytics
dashboards & reporting
Data Models
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