I am trying to pivot data from an excel worksheet, which has multiple year
columns (all the year columns are formulas based on other columns). The data
in the year columns is a combination of numbers and words. I am trying to
have the pivot table set up to pull the data by country then by year. I want
it to count haw many of each of the numbers is listed for each year. The
results are accurate when I pivot one year at a time, but when I have two or
more years, all of the data is the same for each year, which is not correct.

Any help would be great.
--
NCS