Changing Default Properties:

Changing Default Properties:

We can change  the Default properties like Color, Shape, Aggregations,
Comments, Aliases,Sort, Number Format.

EX:
1) Drag the [Region], [Sales] onto Work Area.
2) [Sales] takes the Sum as default aggregate function.
3) Right click on [Sales] in measures window, click on Default Properties,
click on "Aggregation", select "AVG"
4) Again drag the [Sales], Now it takes "AVG" as default aggregate.

And we can use this option & change the Data Format,

EX:
1) Drag the Region on to Rows shelf, Sales, Profit on the Column Shelf.
2) Create a calculated field to get the Profit % like below,

 Name: Profit %
Syntax: Sum([Profit])/sum([Sales])

4) Add the above calculated field to Column shelf, then this field gives the O/P t as 0, because we did not define the no of decimals, integers.
5) Now right click on Profit % in Measures window, click on change Default Properties, click on Number format, then select "Percentage"
6) Now we get the O/P in percentages.