Prokuria Support

Buyer

Pivot Report

In this article we will explore the Pivot Report, we will understand how and for what to use it.

Similar to Excel, these reports organize information in a matrix format. Thanks to the resemblance to Microsoft Excel, the learning curve is very short, users being already accustomed to the interface and the logic behind it.

In addition to excel, pivot reports relieve the users of the difficult task of aggregating the data sources, these being already predefined

2019-11-26_15-42-15 Sectoare Raport Pivo

Below we describe each area of ​​the interface:

Area 1 - Filter Fields (highlighted in green)
  • It is the area of ​​fields used for filtering. The results shown in the report are pre-filtered based on them.

  • The filtering itself can be done in any section by clicking on the funnel symbol next to each field.

  • Its usefulness comes when you want the filtering to be performed on certain fields that will not appear in the report anywhere so as not to visually overload it.

Area 2 - Data Fields (highlighted in red)
  • This is the area where the numbers for the items in the table are displayed.

Area 3 - Row Fields (highlighted in purple)
  • It is the area for placing left-sided table headers

  • All values ​​are grouped according to the order in which they are placed.

  • In the example presented we observe the order: Event type, Event name, Supplier and Currency. The information is grouped based on this order.

Area 4 - Column Fields (highlighted in yellow)
  • It is the area for placing the table headers for columns.

  • All values ​​are grouped according to the order in which they are placed.

  • In the example presented we observe the order: Year and Quarter. The information is grouped on the basis of this order.

Area 5 - Field Picker Buton (highlighted in black)
  • Placed in the upper-right corner

  • Opens a window where you can select or deselect fields and place them in one of the 4 areas mentioned above.

  • The fields can be selected either by ticking / clearing the box to their right or by dragging them to the appropriate area

Also, all fields, regardless of the area they are in, can be used for ascending (upward arrow) or descending (downward arrow) sorting by clicking on the icon next to each field.

Field Picker Window

Like the interface described above, it also contains 5 regions: the filtering one, the one for values, the one for rows, the one for columns and a region that contains all the fields available for selection and their status expressed by a checkbox (selected / unselected). The last region described is marked with 5 in the image below. The other regions are marked with the number and color of the area directly in correspondence with the first image presented.

2019-11-26_16-58-3Sectoare selectie camp

Region 5 - All available fields

Below you will find a complete list of them together with a brief description to better understand their purpose.

No.
Name
Description
1
Bid Placed
The unit price quoted by the supplier
2
Currency
The currency in which the event is quoted upon: EUR, USD, RON etc.
3
End Date
The date the event ended
4
Event Name
The name of the event
5
Event Type
The type of the event: Request. Reverse, Forward, Dutch etc
6
Item Budget
The budget at the item level
7
Item Category
The category of the item
8
Item Name
The name of the item
9
Month
The month in which the event ended
10
Project
The project within which the event is being held
11
Quantity
The Quantity requested for each item
12
Quarter
The quarter in which the event ended
13
Selected
Describes the winner stats of the event's suppliers. Has the values: Yes/No
14
Start Date
For a RFQ, the system displays the publication date. For the rest of the events, the system displays the start date
15
Supplier
Supplier's email address
16
Total Bid (Sum)
It represents the last total quotation placed by each supplier and is calculated according to the formula: Quantity * Bid Placed (Quantity requested multiplied by the unit price)
17
Um
Unit of measurement (ex: pcs, kg, l)
18
Year
The year the event ended

Now that we understand what each element means and the information contained in each available field, we can begin to use this report to obtain useful information. Below are some examples of reports for real business scenarios;

Report with the winning suppliers split by years and quarters, grouped by event, item, currency and auction price - we display the winning suppliers with whom we collaborate along with other helpful information to better understand the market

Report with the number of events performed each year and each quarter - we measure the degree of adoption and overall use of the application in the company

Report with the evolution of the winning suppliers' product prices by years and months - to determine the price variation in the market by time interval, thus being able to estimate a trend

Are you stuck in anyway? Don't worry, we're here for you. Drop us a mail at support@prokuria.com and we'll get back to you.