Hi all,
i am trying to create a measure in a pivot table that gives me a distinct count for a text field.
Here the example. Basically i need to create the measure "family count":
Unbenannt.JPG
Thank you!
Hi all,
i am trying to create a measure in a pivot table that gives me a distinct count for a text field.
Here the example. Basically i need to create the measure "family count":
Unbenannt.JPG
Thank you!
Hello HR85 and Welcome to Excel Forum.
I am assuming that you are using a version of Excel (not windows) that supports Power Pivot.
Attached is a file that illustrates one way to accomplish what I believe you want.
1. Convert the data into an Excel table (Ctrl + t)
2. Add the table to the data model
3. Add the following measure: Family Count:=DISTINCTCOUNT(Table1[Family])
4. Produce a pivot table from the data model with category in the Rows area and the Family Count measure in the Values area
For future reference you may get faster results if you utilize the information in the banner at the top of the page to upload a sample Excel file to your post.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks