Let’s show how to sort rows in the table on the following example report: Filters are turned off. Product subcategories are on the rows, years – on the columns. Using this example report let’s sort the rows in the table in the descending order of sales in 2017. Press the right mouse button over the […]

If you are granted with appropriate rights by an administrator then in report designer you will be able to create your own dimension members and measures based on the existing ones, both for usual reports and for “Interactive Dashboard” reports. Let’s take a deeper look at the process of creating calculated measures and dimension members.

You can create your own calculated measures and use them just the way you do it with ordinary measures. To create a new calculated measure press the right mouse button anywhere in the measures list. You will see the context menu, which will give you an ability to add calculated measures: After pressing “New Measure […]

In the previous chapter you created a calculated measure of “Relationship” type. In this chapter you will see the example of measure of “Parallel Period” type. For example, let’s create a measure showing the value of “Reseller Sales Amount” in the same month of the last year, and use this measure to compare the bikes […]

Calculated measure type “Growth” lets you create a measure that will show an absolute or relative growth of another measure. Let’s create a measure that will show a relative growth in percents of “Resellers Sales Amount” measure in this month comparing to the previous month, and use that measure to show the sales growth of […]

Rolling measure type is used to show an average or total value of some measure in a certain time period. For example, you can create a measure that will show an average profit for the last three month. To do that, create a new calculated measure of “Rolling” type: In the next window fill in […]

“Period to Date” calculated measure type is used to show a total or average value of some existing measure from the beginning of some period to the current date. For example, if you need to draw a chart representing the growth of total sales amount during a year, you can create a calculated measure, showing […]

When users create their own measures, all of them are automatically placed to “My Calculations” folder: Users can create their own trees of folders, but all of them will be under “My Calculations”. Let us look at the example with measures that we’ve just created. In order to manage folders, click on any place in […]

You have the possibility to create your own dimension members, based on the existing ones. To add calculated members to some hierarchy you have to click with the right mouse button on that hierarchy in the hierarchies list. In the context menu select “Calculated Members…”: After that a window will appear for managing the calculated […]

You can create numerical parameters that allow the user to affect calculated measures, sets and members dynamically: To create a numeric parameter, right-click anywhere in the parameter list. A pop-up menu appears allowing you to add a parameter: By clicking on the “New Parameter …” menu item a wizard to create a numeric parameter appears: […]