[go: up one dir, main page]
Scribd
Upload
21 views8 pages

Change_the_default_aggregation_for_a_measure

Uploaded by

shailenderojha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
21 views8 pages

Change_the_default_aggregation_for_a_measure

Uploaded by

shailenderojha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 8

STEPS FOR CHANGING THE DEFAULT AGGREGATION FOR A MEASURE

METHOD-I: IN THE VIEW AREA (WITH THE MEASURE PILL


IN EITHER ROWS OR COLUMNS OF THE VIEW)

STEP 1: By default, the aggregation for


sales will be SUM(Sales).
STEP 2: Right-click the data field (i.e., SUM(Sales))
STEP 3: Select the required aggregation e.g.: "Average"
STEP 4: Ensure that the updated aggregation is visible in
Rows/Columns of the view i.e., AVG(Sales)
METHOD-II: IN THE DATA PANE (BEFORE MAKING USE OF
THE MEASURE IN EITHER ROWS OR COLUMNS OF THE VIEW)
STEP 1: Select the measure for which the aggregation needs to be changed.
STEP 2: By default, the aggregation for sales will be Sum.
STEP 3: Select the required aggregation e.g.: "Average"
STEP 4: If we make use of the Sales measure in a new view either in Rows or Columns
the aggregation level will be the updated one i.e., AVG(Sales)

You might also like