🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

How to show grand total on drillthrough view?

Nafiul asked on December 22, 2019

I want to display the GrandTotal on drill-through view and add a parent header over the main headers. Have there any option to implement these functionalities?


3 answers

Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 23, 2019

Hello, Nafiul,
Thank you for reaching out to us.

  1. We would like to kindly inform you that the drill-through view is dedicated to displaying specific members from which the clicked cell is calculated. The total of the clicked measure is also displayed in the Details section.
    However, in case grand totals for all measures have to be shown, we would recommend implementing your own drill-through pop-up window that would display the grid based on data received from the cell clicked.
  2. For now, there is no option that would allow creating additional headers over existing ones.

Please contact us if any questions arise.

Nafiul January 9, 2020

Hello Illia,
Thank you for your response. How should I get the data received from the cell clicked?

Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 9, 2020

Hello, Nafiul,
Thank you for your feedback.
The data representing the cell can be obtained as a Cell Data object containing information about the cell; however, the data set displayed within the drill-through view can not be provided.
We would like to kindly recommend transmitting the received information to the server-side in order to specify the data set needed to display within the pop-up. We suggest creating an instance of Flexmonster inside the pop-up and pass the received data set in it.
The Cell Data object itself can be obtained in several ways, for example, with a celldoubleclick event.
Please check out a simple example we have prepared for you, demonstrating usage of the celldoubleclick event.
More about the Cell Data object: Cell Data Object.
We hope it works for you.
Kind regards,

Please login or Register to Submit Answer