Link to home
Create AccountLog in
Avatar of obad62
obad62

asked on

How to use Pivot Table slicer with txt data

Hi Exerts,

in the attached file sorted and filter data. and created summary sheet using pivot table with slicer, the question I do not want to calculate or count what I need is to show only available whence I choose one from the slicer.  It will be a dynamic filter.

thanks
Banks-list.xlsx
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

I'm not really sure what you want to see but if you want text data visible, it has to be in the row (or column) area.
Avatar of obad62
obad62

ASKER

thank you rorya for your question.

please see attached pic, it may show you what am looking for.
data-filter.jpg
As I mentioned, you will need to put the fields into the row area of the pivot table. You will also probably want to change the layout to a Tabular format and turn off subtotals for all the fields.
Avatar of obad62

ASKER

I don't know how, can you please help me and show an example in the excel sheet?
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of obad62

ASKER

Big Thank you
Avatar of obad62

ASKER

Exactly what I need.