MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

pivot table fields grouped by partial values

  Asked By: Heath    Date: Feb 26    Category: MS Office    Views: 2257

I'm trying to create a pivot table where one of the row fields is a
combination of default text and additional text. I would like to group
all the rows with the same default text together as one row value. is
there a way to do this?

for example

do not batch - broken
do not batch - pending
do not batch - missing documents

I would like all the lines that begin with do not batch - to be grouped
as one.. kind of like using a wildcard do not batch - *

is this possible?



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on pivot table fields grouped by partial values Or get search suggestion and latest updates.