This is PRO license module that can help you crunch the numbers.
If you are used to Pivot in Excel, then you will find this very similar.
In this article we will explain how to:
- Organizing data
- Visualize your data
- Average values
- Formatting values
- Conditional formatting of values
- Create new Calculations
- Share a favorite
- Receive a shared favorite
First of all, you need to select the data you want to appear in your favorite.
- Click at the at the star to create a favorite.
- Name the favorite
- Select the seasons you want to compare style data.
- Click ok.
Style data will appear by default divided by season/category.
You can change this by selecting data as described below.
You can change columns and rows by clicking the "Fields" button.
- Use the search field to find the option you want to include
- Drag and drop it to either:
- report filter (use for filtering data)
- rows / columns
- value (either count or sum of value)
Each time you make changes, then a green save button will appear at the favorite tab.
Make sure to click save, if you want to keep your changes for next time.
Visualize your data
You can present data in different charts.
- Select a chart and choose the chart you want to have
You can export both the grid and the charts in different formats.
In this module, you can also get the average values presented.
This is for example useful when looking at margins.
- Go to fields and search for a numeric option (for example Mark up)
- Drag it to Values
- Change from "Sum" to "Average"
In case too many digits appear, you can select "Format" and define the number of digits you want to appear.
Conditional formatting of values
Let's say you want to highlight values above or below a certain amount, then you can use Conditional formatting.
In this case, I want to highlight Mark Up values less than 3.
Create new Calculations
For all the numeric fields in Delogue PLM you can create Calculations.
In this example, I want to calculate an expected turnover by multiplying Expected Quantity and Wholesale Price.
Share a favorite
When you have set up the perfect Analytics report you might want to share it with others so they have access to the same setup.
You can easily share a saved favorite with your colleagues.
Simply select the favorite you want to share then you click on the "Share Report" button
Now you will get a pop-up where you can select the users you want to share your favorite with.
Receive a shared favorite
When you receive a Share Analytics favorite it will be added to all your other favorites.
You can decide what to do with it. You can choose to edit it, rename it or delete it.
It is important to rememeber that whatever changes the Receiver makes on his copy of the shared Favorite has no influence on the original Favorite.