What is a Pivot table/grid? According to Wikipedia it is a data summarization tool found in spreadsheet applications. Still when I was a child I learned that people understand the best when they see an example.
Consider you have a table that contains the nutrition of given food, say a pizza:
| Group |
Name |
Quantity |
| Carbohydrates |
Total carbohydrates |
27.3 |
| Carbohydrates |
Total disaccharides |
5.7 |
| Carbohydrates |
Total polysaccharides |
21.6 |
| Minerals |
Calcium |
147 |
| Minerals |
Phosphorus |
150 |
| Minerals |
Potassium |
201 |
| Minerals |
Copper |
0.13 |
| Minerals |
Magnesium |
19 |
| Minerals |
Sodium |
582 |
| Minerals |
Selenium |
4 |
| Minerals |
Total iron |
0.7 |
| Minerals |
Zinc |
1.07 |
| Vitamins |
Beta-carotene |
173.8 |
| Vitamins |
Nicotinic |
1.5 |
| Vitamins |
Total vitamin B6 |
0.127 |
| Vitamins |
Total vitamin D |
0.3 |
| Vitamins |
Total vitamin E |
2.1 |
| Vitamins |
Vitamin B1 |
0.1 |
| Vitamins |
Vitamin B12 |
0.59 |
| Vitamins |
Vitamin B2 |
0.16 |
| Vitamins |
Vitamin C |
10 |
In the data above you see that every nutrition is contained in a specific Group - 3 groups and 21 nutrition in total.