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.
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.
Thanks Roman, But what was the recommended way in this case, can you please explain it again ?
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?
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 ?
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.
in this way, can we show new table instead of pivot ?
Can we have a call Roman, if possible ?
Thanks Roman, I am good for now. That helped
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 ?
Hi Roman, Gentle reminder !
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.