Select Values and Aggregations

1. Open config.xml for editing.
2. Insert blank XML template for default slice after <dataSource> block :
   

   <config>
     <dataSource type="...">
       ...
     </dataSource>
   
     <defaultSlice>
       <axes>
         <axis name="rows"> </axis>
         <axis name="columns"> </axis>
         <axis name="pages"> </axis>
       </axes>
       <measures> </measures>
     </defaultSlice>
   
   </config>

3. Define which values you would like to be shown on the report. You can add several values:

   <measures>
     <measure>[Measures].[Price]</measure>
     <measure>[Measures].[Quantity]</measure>
   </measures>
   

   Also, you have to specify where measures should be shown: add measures hierarchy block to columns (in example) or rows tag:

   <axis name="columns">
     <hierarchy>
       <dimensionName>[Category]</dimensionName>
       <hierarchyName>[Category].[Category]</hierarchyName>
     </hierarchy>
   
     <hierarchy>
       <dimensionName>[Measures]</dimensionName>
       <hierarchyName>[Measures]</hierarchyName>
     </hierarchy>
   </axis>

4. Add Aggregations for Values
   You can define an aggregation for each value you add by setting aggregation property of <measure> tag.

   <measure aggregation="Count">[Measures].[Quantity]</measure>

   The following aggregation functions are available for CSV data source:

   Function	Summarizes
   Sum	The sum of the values. This is the default function for numeric data.
   Count	The number of data values
   Average	The average of the values
   Max	The largest value
   Min	The smallest value
   Product	The product of the values
   Percent	Values in percent