fixed outcomes inside cell of a pivot table / chart
Hello,
I am trying to build a chart or a pivot table with a/different variables summing automatically inside a cell
for example, my variables are Fruit (apple, cherry and pear), Color (red green blue) and SIze (small, medium, big) , is it possible to creat an automatic chart like this one ?
BIG
MEDIUM
SMALL
Header 4
apple red
apple blue
cherry red
pear green
cherry blue
cherry red
.
It s very likely this subject has been already explained, but I do not find it.