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.