![]() |
#1
|
|||
|
|||
![]()
Hi
I would like to create a simple dynamic table in a spreadsheet somewhat similar to pivot table functionality. Is it possible to create a table where the data in the table changes dynamically based on a filter for the table? This would be similar to having a drop down filter for a pivot table. Paul |
#2
|
|||
|
|||
![]()
Hi Paul
If you are using Pivot Tables and you use the Filter Column as your Page field then when you select a different criteria the Pivot Table will recalculate. Hope this helps. Tony(OTPM) |
#3
|
||||
|
||||
![]()
Have a look at the attached sheet which contains a small pivot table.
I have used the slicer which is found on the Insert Tab. You can choose the slicer to filter pages, columns and rows in the pivot table. |
#4
|
||||
|
||||
![]()
sorry thought it was attached
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Please answer my question related to MS Excel 2007. Part 1. | MonkiaSaini | Excel | 7 | 11-24-2011 07:33 AM |
Please answer my question related to MS Excel 2007. Part 6. | MonkiaSaini | Excel | 1 | 05-30-2010 12:02 PM |
Please answer my question related to MS Excel 2007. Part 4. | MonkiaSaini | Excel | 0 | 05-09-2010 04:19 AM |
Please answer my question related to MS Excel 2007. Part 2. | MonkiaSaini | Excel | 0 | 05-09-2010 04:16 AM |
Excel 2007 - Question on conidial formatting? | jerrymbna22 | Excel | 2 | 03-24-2010 11:48 AM |