Main Screen

Fix or Float View		When this button is not pressed, the view is "floating" over all folder. A floating view is initially on top of all other views. When you change the current folder, any floating view remains on the top. Once you press this button, the view is fixed in the current folder and will disappear as soon as you change the folder. [back to top]

View Setup		Press this button to select or deselect columns from the view, to change the order of columns, and to add foreign columns ( columns from other related tables ) to this view. [back to top]

Duplicate View		Use this button to make a copy of the current view. This is a quick way to create another view on a different portion of the table using different filters, different columns, or different pane types. [back to top]

Print		Use this button to print the current view. First you will see a preview of the printed pages on the screen, then you will have the option to send the pages to the printer. [back to top]

Find

Filter Buttons		This button is composed of three individual buttons. The left part will set a filter on the current cell value. For example if you are at the Product column and the current value is Jacket, then if you press this button, only rows that have Product = Jacket will appear. Now if you move to another column say Color and your current cell has Black and press the button again, then the filter will be set on Product = Jacket AND Color = Black. This means you can press the filter buttons many times, each time you are adding a new value to the filter. All values are ANDed together. The middle button is mainly an indicator to whether there is a filter set or not. When there is a filter set, a green indicator appears on the button. You can use it also to reset all filters. The right button removes values from the filter. So, if you have the above filter set on Black Jackets, and press this button, Black is removed from the filter. Always the last value is removed, when you press this button. The filter is now on Product = Jacket. If you press it again, Jacket is removed from the filter and the filter is cleared. The filter button is designed to provide for fast and easy analysis of your data. Each time you change the filter, all panes are recalculated for rows in the filter. [back to top]

Index		The index button is composed of two individual buttons. The left button creates (or edits) the current index. The right button is mainly an indicator to whether there is an index in use or not. You can also use this button to set and rest the index. [back to top]

Virtual Columns		Use this button to create any type of Virtual Columns. You can create: Filter Columns Range Columns Keyword Columns Classification Columns (Discovery Edition Only) Formula Columns (Discovery Edition Only) [back to top]

Summary		This buttons invokes the Create Summary Table Dialog which will help you summarize your data table on any column or group of columns. For example you can summarize your sales data using the State column. In this case the summary table will contain one row for each state. Each field contains a summary of the original data, i.e. total, average, etc. [back to top]

Facts		This buttons invokes the Fact Discovery Engine. Interact with the Fact Engine in the Discovery Edition. Fact Engine in the Office Edition [back to top]

Panes		View Panes [back to top]