Can we open another dataset while clicking on the cell of the pivot table

Hello, Ranjith,
 
Thank you for your question.
 
Yes, it is possible to open another pivot on cell click.
This can be achieved using Flexmonster's cellclick event.
Please see the following JSFiddle for illustration: https://jsfiddle.net/flexmonster/fdk4pygh/.
In the example, when a cell is clicked, a new pivot table is created.
 
Depending on the use case, here are a few more examples that may be of interest:

1. Customizing the context menu to open a new pivot table: https://jsfiddle.net/flexmonster/rL38fqub/.
2. Customizing the context menu to open a new pivot in a pop-up: https://jsfiddle.net/flexmonster/1rm53nt9/.

 
Please let us know if this helps.
 
Kind regards,
Vera