Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table: Get "customized" detail
Hi, I am needing some help on Pivot Table (Excel 2003). I have two
sheets, one for the source another one with the Pivot : Source: Name Group YTD Res 1 5 0-10% Res 2 5-10 0-10% Res 3 5 11-20% Pivot: Group YTD 0-10% YTD 11-20% 5 1 1 5-10 1 0 Basically the Pivot counts the number of names falling on each category (group/YTD). Of course double click on the pivot area creates a new sheet with the detail behind the data. But this is not what I need. What I need is in the same Pivot tab, on the right of the Pivot table, get the list detail of names behind the clicked number. So if I click on the "1" on the pivot Group 5 and YTD 0-10% I get in the right the "Res 1". It should be doable if I can identify where the user clicked, loop in source data, create an array with values matching the double clicked cell, and placing the array in let's say range E1 in Pivot tab. But I have no idea how to do it with VBA.... Can sombedy help?? Thanks in advance, Cecilia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
Pivot Table Report Filter - "OR" instead of "AND" Multiple Filters | Excel Discussion (Misc queries) | |||
Pivot table "Group and Show Details" vs. "SubTotals" | Excel Programming | |||
OfficeXP "Cannot open pivot table source file" when refreshing pivot table | Excel Programming | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |