Support Import

Developing the Grid

After selecting the grid, we can now set all the items shown in each of the columns. Moreover, we can right click on the columns to rename them.

In this case, we will add the following columns.

  1. Dimension 1 (Full Name)

  2. Dimension 2 (City)

  3. Continent

  4. Date

  5. Date (Day Of Week)

  6. Date (Month)

  7. Dimension 4 (Amount)

  8. Dimension 5 (Category)

In order to view only the results of this KPI, we will add the Name of the KPI as the dimension so that we are able to filter it using the filter editor.

filteringgrid.png

The final result, is a grid showing each expense with the name of the employee, the city, the continent, exact date, day and month that the transaction took place as well as the amount and the category of the expense.