rainx
Board Regular
- Joined
- Jul 4, 2008
- Messages
- 210
Hi all,
I needed some help in pivot table. I have a 2 sheets in the workbook. Sheet 1 consist of a pivot table and Sheet 2 consist of a normal table with the cells linked to the pivot table to retrieve the values. I understand I can do a drilldown on the pivot table to show the data. However, is there a way to do so by clicking on the cells from the normal table on sheet 2 which have been linked to the values of the pivot table?
The reason of me doing this is I needed a customized table with formatting for presentation purpose and thus do not want to use a pivot table for the presentation.
Will anyone be able to help? Thanks in advance!
I needed some help in pivot table. I have a 2 sheets in the workbook. Sheet 1 consist of a pivot table and Sheet 2 consist of a normal table with the cells linked to the pivot table to retrieve the values. I understand I can do a drilldown on the pivot table to show the data. However, is there a way to do so by clicking on the cells from the normal table on sheet 2 which have been linked to the values of the pivot table?
The reason of me doing this is I needed a customized table with formatting for presentation purpose and thus do not want to use a pivot table for the presentation.
Will anyone be able to help? Thanks in advance!