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.
Many thanks
ER