Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Controlling Pivot Table Page-Field
Controlling Pivot Table Page Field.
Thank you for looking at this query, I have tried the code, but there is an error. I have tried this code, but ran into run-time error: "Unable to set the_Default Property of the Pivot Item class" What I have done: 1.Cell C2: key in date (31/03/07 or 28/02/07) 2.Cell C2: use vlookup & indexmatch, it doesn't change the PivotField, PageField. ---Taken from the community------------------------------- Private Sub Worksheet_Change(ByVal Target As Range) Dim pt As PivotTable Dim pf As PivotField Dim pi As PivotItem Set pt = Worksheets("Sales Pivot").PivotTables(1) Set pf = pt.PageFields("End-Mth") If Target.Address = "$C$2" Then Application.EnableEvents = False For Each pi In pf.PivotItems If LCase(pi.Value) = LCase(Target.Value) Then pf.CurrentPage = pi.Value Exit For End If Next pi Application.EnableEvents = True End If End Sub What I wanna do: Cell C2: Use Reference formulas to change Pivot-PageField Sheet 1: Data entry Sheet 2: Central Control (this is where C2 is AND uses Vlookup & IndexMatch) Sheet 3: Pivot Table (change according to sheet 1) Thank you for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Page Field Area Broken | Excel Discussion (Misc queries) | |||
Pivot Table Page Field | Excel Discussion (Misc queries) | |||
I cannot drag a Pivot Table field into the page area | Excel Discussion (Misc queries) | |||
Pivot Table Page Field | Excel Discussion (Misc queries) | |||
Pivot Table - Filtering Page Field | Excel Discussion (Misc queries) |