I want to open a modal dialog to show more detail when the user clicks on a cell in the Pivot Table. I am developing the Pivot which the user can click on the cell and will generate the Grid Table based on the category which the cell currently is.