N
Nicole
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.
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.