On Pivot

[Guest]

Can I place "Text" in the "data items" of the Pivot table?

 

[Roger Govier]

Hi

No you can't.
You could add the filed to the Row area, and again to the Data area, and the
PT will show a count of the occurrence of the text items.

 

[Guest]

Thanks Roger..but is there a way in xl where we cn do this?
I mean text to text comparison.

 

[Roger Govier]

Hi

I'm not sure what you are meaning. Can you give an example?

 

[Guest]

for ex; lets say i have 5 columns that contain only texts and no numbers.

Customers Residential City Model Purchased Repeat Customer
XXXXX RRR A0001 Yes
YYYY PPP A0002 No
ZZZZZ KKK A0003 No
AAAA RRR A0001 Yes
BBBB PPP A0003 Yes

This extends to 10000 rows. No I wish to make a table such that I know that
in a particular city, a particular model was purchased by these customers.
Should ideally look like:

City/Model A0001 A0002 A0003
RRR XXXX,AAAA
PPP YYYY BBBB
KKK ZZZZ

I hope you get it or if an alternate way is possible pls share., thx

 

[Roger Govier]

Hi

The only way you can represent this as a PT report is to have
City followed by Customer as row fields
Model as a column field
Count of Model as the data field.

Your report will show Customers within City, with a number appearing under
the model they purchased

Alternatively, you could sort your database by City.
Apply a filter Data>Filter>Autofilter
Use the dropdown on City to select an individual city, then you will see all
of the relevant data.

 

[Guest]

i tried in exactly the same way u hv mentioned...but the problem didnt
solve...i think i will hv to find further alternative ways...thanx so much
for being helpful..