Difference between revisions of "Convert to Formula"
(Added categories) |
|||
| Line 1: | Line 1: | ||
The {{Menu|XLCubed|Convert to|Formula}} option converts a Grid report into XLCubed formulae. | The {{Menu|XLCubed|Convert to|Formula}} option converts a Grid report into XLCubed formulae. | ||
| + | |||
| + | In XLCubed you can easily convert an existing grid report to a formula report. | ||
| + | |||
| + | To do this right-click on the grid, XLCubed, Convert to, Formula as below: | ||
| + | |||
| + | You will get a message asking you to confirm that you wish to convert to formula. | ||
| + | |||
| + | If you are converting a grid report that contains slicers you will also get a message that links to any slicers in the report will be removed and that you can manually recreate these links. | ||
| + | |||
| + | To manually recreate links to slicers you need to follow these steps: | ||
| + | |||
| + | 1. Right-click the slicer and choose edit slicer: | ||
| + | a. on the settings tab – check box ‘Update range with selection’ and point to the cell location where the slicer choice is located; (if not already set) | ||
| + | b. select ‘Caption’ from the drop-down (if not already set) | ||
| + | |||
| + | 2. Next you will need to edit your formula statement to point to this cell location – right-click on a cell in the formula report, edit the XL3lookup statement as below to make sure the cell location which holds the slicer choice is correct. | ||
| + | |||
[[Category:Formula Reporting]] | [[Category:Formula Reporting]] | ||
[[Category:Grid Reporting]] | [[Category:Grid Reporting]] | ||
Revision as of 11:33, 23 March 2012
The XLCubed > Convert to > Formula option converts a Grid report into XLCubed formulae.
In XLCubed you can easily convert an existing grid report to a formula report.
To do this right-click on the grid, XLCubed, Convert to, Formula as below:
You will get a message asking you to confirm that you wish to convert to formula.
If you are converting a grid report that contains slicers you will also get a message that links to any slicers in the report will be removed and that you can manually recreate these links.
To manually recreate links to slicers you need to follow these steps:
1. Right-click the slicer and choose edit slicer: a. on the settings tab – check box ‘Update range with selection’ and point to the cell location where the slicer choice is located; (if not already set) b. select ‘Caption’ from the drop-down (if not already set)
2. Next you will need to edit your formula statement to point to this cell location – right-click on a cell in the formula report, edit the XL3lookup statement as below to make sure the cell location which holds the slicer choice is correct.
