To retain such formulas as part of the function grid, you must leave one empty row between the grid and the cell containing the formula and include the empty row in the range of cells selected for the formula definition. You can use Excel formulas, for example SUM, with function grids. Although you can have multiple reports on a worksheet, you can have only one function grid. For reports whose members may change more often, tables and charts are better report types. For this reason, function grids are most useful for reports in which members remain reasonably static. To refresh both data and members, you must reinsert the function grid into the sheet. When you refresh a function grid, data cells are refreshed members are not.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |