TEXT IN A PIVOT TABLE's VALUE FIELD

[Shafique]

I created a table as belw. and want to get its text data(CODE) in a pivot table's value field.

Table1........

NAME CODE
1 ABC AD-01
2 DEF AD-02
3 GHI AD-03

 

[naveeddil]

See Bill's post here: Pivot Table With Text in Values Area

Hey, I dont want to start a new post as this is somehow related so asking my question here.


Dear I am coming from Bill's post actually and I have been looking for some additional work in the same DAX formula. As described in the end that second formula
=CONCATENATEX(Values(Table1[Code]), Table1[Code], ", ") will eliminate duplicates.

Great! But I want formula modification to count the Duplicates, i.e Date, 2 Fig, 3 Banana, 5 Guava

 

[RoryA]

That would require a very different measure so please start your own question.

 

[alansidman]

Look at this link

Want to Put Text into a Pivot Table instead of numerical data

alansidman submitted a new Excel article: Want to Put Text into a Pivot Table instead of numerical data - Use Power Pivot to Place Text in your PT Have you ever wanted to put Text into the fields in a Pivot Table instead of Values. Well, I found this link where Bill Jelen shows you how using...

www.mrexcel.com