Slicer Help?

[ppenguin33]

So I created a slicer for my city and I want it to show me the list of address and then when I click on the address I want it to show me the information associated with address.

 

[scottsen]

I believe everything you are describing (if I am understanding correctly) should happen magically, by default. Is that not what you are seeing?

 

[ppenguin33]

Yes, but I want to change the way it appears, I have two columns of information that needs to be shown. and I just wanted to change the way it appeared. I want to be able to click it and it all appears under the address not in a column across from it.

 

[scottsen]

If i am understanding correctly...

Using cube formulas will give you more flexibility in formatting the output, see: Cross-Filtering in Slicers with Cube Formulas « PowerPivotPro

And if you are using SharePoint, this might be an interesting option: “Drill Across” in PowerPivot – Live Demo « PowerPivotPro

 

[ppenguin33]

I'm using excel 2010 I don't see the button for the OLAP thing anywhere.

 

[scottsen]

There is a screen shot that is correct, and it should certainly be there. You have to create a pivot table first, and click on it. Then on the Pivot Table Options tab you will find the Olap Tools drop down.