Pivot Table

  • Thread starter Thread starter Jay Gustafson
  • Start date Start date
J

Jay Gustafson

Hello,

I have a report that I do daily. It involves the use of several pivot tables. In the pivot tables there are fields, "ASSIGNED_TO" & "ASSIGNEDTOUSERNAME". Within those each day I have to keep selecting & unselecting certain names that are in those lists. Is there any way to do this with coding? So that I click a button and it only has the names I want checked?

Thanks,
Jay Gustafson
 
You could record a macro as you select specific names, then run the
macro as required.

Or, add a column to your source table, and assign users to groups. Add
the Group field to the page area, and you can view one or more groups.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting in a Pivot Table unselected fields 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Average of Subtotals in Pivot Table 0
Pre-configuring Pivot table "views" 4
Lose formatting on pivot tables 3
Pivot table field list missing 5
grouping dates in a pivot table 1
Sorting the pivot table field list 4

Back
Top