G
Guest
Hi, I am new to Pivot tables. I created a pivot table based on a 15 column
table in a worksheet. There are 4 types of text strings that are repeated in
one of the columns. My pivot table display the 4 string types and reports the
count of each type. But it does not count the text strings in 14 adjacent
rows. It counts the strings in all the oher rows, just not these 14. Tried
refreshing the data still did not work, retyped the strings does not work.
Your help is much appreciated
table in a worksheet. There are 4 types of text strings that are repeated in
one of the columns. My pivot table display the 4 string types and reports the
count of each type. But it does not count the text strings in 14 adjacent
rows. It counts the strings in all the oher rows, just not these 14. Tried
refreshing the data still did not work, retyped the strings does not work.
Your help is much appreciated