Menu
Download Free Trial

Can I supply the data for drill through instead of default data available

Currently I am giving the data to the pivot which is already aggregated (in JSON format), so now when I am clicking on the drill through, I want to first make a server call to get the detailed data (which can be done by having my method inside celldoubleclick event) but then can I supply this new data for the drill through ?
I know you would say that instead of initializing the pivot with aggregated data, try to send the detailed data itself, but lets say we cant do that right now.

13 answers

Public
Roman Petrusha Flexmonster April 27, 2017

Hi Sohan,

I understand your problem but unfortunately, there is no quick solution. We already discussed this issue and there is no better way that we already recommended to you.

Regards,
  Roman

Public
Sohan April 27, 2017

Thanks Roman, But what was the recommended way in this case, can you please explain it again ?
 
 

Public
Roman Petrusha Flexmonster April 27, 2017

Sohan,

Here is the required demo http://jsfiddle.net/flexmonster/dbaw72fw/

Please right click on the grid to see Open in New Pivot. 

Does it help?

Regards,
  Roman

Public
Sohan April 27, 2017

Oh yes, I am aware of this one, which is still our one of the requirements. But now we have a scenario where we want to provide the data to the flat table which comes up as a result of drill through.
Can you confirm there is no way to achieve this right now ?

Public
Roman Petrusha Flexmonster April 27, 2017

Sohan,
There is no way to provide data to drill through table but you can use this sample to achieve your goal. I understand it’s not the same but you can add a new table in flat mode and fill it with your data.

Public
Sohan April 27, 2017

in this way, can we show new table instead of pivot ?

Public
Sohan April 27, 2017

Can we have a call Roman, if possible ?

Public
Roman Petrusha Flexmonster April 27, 2017

Yes, you can show new table over the pivot (http://jsfiddle.net/dbaw72fw/20/) or hide it at all (http://jsfiddle.net/dbaw72fw/17/

We can arrange the call for tomorrow.

Public
Sohan April 27, 2017

Thanks Roman, I am good for now. That helped

Public
Sohan May 5, 2017

Hi Roman,
For the new table over the pivot (http://jsfiddle.net/dbaw72fw/20/), I am not getting the close button on the right top which is there when you drill through.
Also I would like to show the details of cell selected from parent pivot onto this new pivot, just like the existing drill through popup.
 How can I get it ?

Public
Sohan May 8, 2017

Hi Roman, Gentle reminder !

Public
Ian Sadovy Flexmonster May 8, 2017

Hello Sohan,
 
Thank you for the details.
Actually, you can change the view of the popup using JS/HTML/CSS.
For instance, please take a look at the following sample – https://jsfiddle.net/flexmonster/1rm53nt9/
I have added a jQuery popup with a close button to show the new pivot.
Also, added the details of the cell selected from parent pivot.
Since this is a demo and it is built on top of the Flexmonster API, you can use the API and change any of this code to suit your needs.
Hope it helps.
 
Regards,
Ian

Public
Sohan May 8, 2017

Thanks Ian

Please login or Register to Submit Answer