How to Manipulate tables in Foodics BI

In this guide will guide you on how to manipulate any tables in Foodics BI. The tables in Foodics BI are flexible 

Each table has the following options:

1. Sort
2. Filter
   • By Name
   • By Number
3. Remove
4. Reset

Sort:

In any table, you can hover your mouse on any column and press on the triple dots "..." then to sort and you can adjust it to be sorted Ascending or descending order

Filter:

To Filter by name: 

You hover on any of the names and press on the "..." then press on Filter

A pop-up will appear to allow me to select the name i wish to filter, I selected here the BBQ section Category name and the table will adjust accordingly

Filter by number

To filter by number you can hover on any number Column, press on the triple dots "...", go to filter, add a condition. In this example, I want to know all the costs above 20. 

Remove:

You can remove a column similary by hovering on any column then press on the "..." followed by Remove. 

This will effectively delete the column for view until you reset

Reset: 

To reset the view back to its original state, on the top right corner you can either undo the last action, redo the undo you did, or fully reset the table view.