Calc Guide

Figure 216: Disabled column sums
A frequent use case for multiple data fields is the aggregation of one
value according to different aggregate functions at the same time. You
can create a DataPilot that shows you the monthly sales values and
shows you additionally the smallest and the largest amounts.
Figure 217: Multiple analyses for the same
data field
Unfortunately, Calc does not allow you to use the same data field
multiple times. For such multiple analyses you have to duplicate the
respective column in the source. This column is then available within
the DataPilot; it just happens to have identical values.
Chapter 8 Using the DataPilot 265