how to get grand total value of measure

Answered
Nil asked on October 19, 2021

Hi Team,
can we read the grand total value of measure if our data source is Azure Analysis Service ??
Please find attached image for your reference .

Attachments:
Grand Total.PNG

3 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster October 20, 2021

Hello, Nil,

Thank you for raising the support ticket.
 
If we understand correctly, your requirement is to retrieve the grand total of the specific measure to use it outside of the component. Could you please provide more information about how exactly these values are going to be used in your application? It would help us to find the most suitable solution for your case.
 
Looking forward to hearing from you.
 
Kind regards,
Illia

Public
Nil October 20, 2021

Thannks Illia,
 
Actually we need this grand total By Measure name .
Second option if we get all measure grand total with measure name is also fine.
We need to display this grand total outside as total .
on same not can we real whole grid?

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster October 21, 2021

Hello, Nil,
 
Thank you for the additional information.
 
We suggest checking out the getData API call that allows retrieving data from the grid and is usually used to integrate with third-party charting libraries. You can use it to retrieve desired grand totals.
 
Please let us know if it helps.
 
Kind regards,
Illia

Please login or Register to Submit Answer