Highlighting helps you to better analyze data. Let’s prepare the table of the next structure: On the rows – “Product Categories” dimension with a whole “Product” level selected under the “Touring Bikes” element: on columns – years 2017 and 2018. Inside the table – “Reseller Sales Amount” measure. Say, we need to emphasize somehow the […]

Apart from highlighting there exists a possibility to «paint» the text on rows, columns and inside the table. To do that select «Table / Formatting» in main menu or the similar item in the table’s context menu. The following form will appear: You can do the same thing from the context menu of the table: […]

Each hierarchy has a set of settings for automatic coloring of its levels. Let us look at the example. Click the right mouse button on the hierarchy “Product/Product Categories” and select “Formatting”: In the window below let us set up the following parameters for the level “Product Categories”: The table will look like this: If […]

For every level of the tab “Hierarchies” you can set up parameters of the body and the header. Let us look at the example: Let us select the following parameters on the tab “Header”: Set us “Apply header formatting to body”: As a result, the table will look like this: If we increase the height […]

Let us look at measure formatting: There is one more tab “Representation” in the dialog where you can set set the number of digits before the decimal point, the currency symbol, the color and the font parameters for the measure. Let us set up the following parameters for the “Reseller Sales Amount” measure: The table […]

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