MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Table User Interface


Posted by George A. on August 10, 2001 10:07 AM

I saw a file that had an interface which asks the user
to select certain fields to create a pivot table (for
example the user could select size, company and sales
volume and then the user would click a button "create
report" and the pivot table would open in a different
sheet.

Any thoughts? Is this a souped up feature or did someone
write something to make it happen?

Any help would be appreciated. thanks


Posted by Mark W. on August 10, 2001 10:09 AM

Sounds like the PivotTable Wizard to me.

Posted by George A. on August 10, 2001 11:02 AM

It wasn't the Wizard.

It had 4 drop down boxes (probably using data validation?)
and within those you could choose what you wanted to see. Like for size you could
select 10-inch and for company you could select
all and for the data select shipments.

Posted by Mark W. on August 10, 2001 12:20 PM

> It had 4 drop down boxes...

The Excel 2000 PivotTable Wizard has such drop down
boxes.

Posted by George A. on August 10, 2001 3:03 PM

The only thing I get when I do the wizard is the ability
to drag and drop fields into the pivot table.

I don't see any to use 1 sheet for the user interface
and then click to create the pivot table.

Is there a special area in the Wizard that I am missing?

thanks