[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

excel pivot table

In my excel pivot table the user can display multiple items from a drop down paramater from a report filter. I want to display in cells what the user selected. How, would i do that?
0
vbnetcoder
Asked:
vbnetcoder
  • 2
1 Solution
 
ScriptAddictCommented:
If you are selecting via drop down boxes, you might want to check out data slices.  This remains viewable, though not as flexable as the drop downs.

So, take your chart and just insert a slicer.  Should be on the pivot table options ribbon.

-SA
0
 
vbnetcoderAuthor Commented:
I have used the slicer before.  I can use that for the this as well but i STILL need to display what the user selected in the cells per my customers request
0
 
vbnetcoderAuthor Commented:
ty
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now