I
IgorM
Hello
I have a table with data as follows
A B
Animal Age
1 Cow 14
2 Sheep 23
3 Cow 87
4 Cow 123
5 Sheep 345
6 Sheep 22
7 Cow 12
8 Sheep 91
It is very simplified of course. I want to have a pivottable and in that
pivottable I want to see how many cows and how many sheeps there are within
a <90 and >90 age band. In other words I want to produce something like
this:
Animal Age < 90 Age >90
Cow 3 1
Sheep 2 2
Total 5 3
Is it possible to do that using calculated field (or other features of
pivottable). I wouldn't like to add any extra columns in the source table to
calculate the age band.
Regards
Igor
I have a table with data as follows
A B
Animal Age
1 Cow 14
2 Sheep 23
3 Cow 87
4 Cow 123
5 Sheep 345
6 Sheep 22
7 Cow 12
8 Sheep 91
It is very simplified of course. I want to have a pivottable and in that
pivottable I want to see how many cows and how many sheeps there are within
a <90 and >90 age band. In other words I want to produce something like
this:
Animal Age < 90 Age >90
Cow 3 1
Sheep 2 2
Total 5 3
Is it possible to do that using calculated field (or other features of
pivottable). I wouldn't like to add any extra columns in the source table to
calculate the age band.
Regards
Igor