The virtual hierarchies are accessible on the tab “Hierarchies”: Let us make an example using a virtual hierarchy with levels “Date/Date. Month” of “Year” and “Product/Color”: Let us set the default settings for all levels: The table will look like this: Let us set up formatting for virtual hierarchies: At the first sight this action […]

There are several rules: Highlight rules have the biggest priority; The measure body formatting have the middle priority; Level formatting rules have the lowest priority. If there are several format rules and some of them are in rows, then the priority belongs to the object which is at the right side. If there are two […]

There is one more tab for levels, measures and measure headers:  the “Separators” tab. The tab allows to set the thickness and color for the lines and separators. Let us look at the example with the following selection on rows and columns: The columns have this: The context contains “Bike” category, measures “Reseller Sales Amount” […]

In the chapter “Change of the Page Structure” we have already reviewed the definition of a designer and the ways of using basic designers. Now let’s review the advanced designers: “Filter” and “Sorting”. Those two designers are situated near the “Rows / Columns” designer:

“Filter” can be invoked both from the context menu of the header: and from the context menu of the tab “Filter”: There are several filtering options here: In the sections 1 – 4 there are quick filters: Top 10 – 10 biggest values; Top 50 – 50 biggest values; Top 100 – 100 biggest values; […]

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 […]

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 […]