Displaying the correct total aggregate of an amount for a GI with 'select top' record is set to 10.

Hi @suemackeown13,

Could you please share the screenshots for more details?

I used the Vendor Summary GI to display details on the dashboard, selecting the top 10 records, and confirmed that only these 10 records appear on the dashboard.

Thank you, I also get only those ten records on a data table and on a pivot, however, we want the totals of these to display on a KPI, and its here that the full total is given and not that for the selected records. 

Hi @suemackeown13 ,

In this case, you should go with @Dipak Nilkanth 's suggested solution. We can't achieve this without customization. You will need to create a Custom View and a Custom DAC with the respective columns. Then, use this DAC to display the top 10 records in the GI and add it to your dashboard.

Thank you. I will go with the suggestion.