Formatting data – dates, numbers, and percentages
Virtually all reports involve displaying numerical information. It is very important to correctly format the numbers. In this recipe, we will create a report which formats dates, numbers, and percentages.
Date transformation and formatting are important in business reports. We will see two ways of displaying MONTH-YEAR from the Shipment Date Key. We will apply some formatting to a numeric column and will also configure a ratio to be displayed as a percentage.
Create a simple list report with Products / Product line, Products / Product type, and Time (ship date) / Date (ship date) as columns from the Sales (query) namespace.
Also, add Quantity , Unit price, and Unit cost from the Sales ...