Difference between revisions of "Convert to Formula"
(Wikified) |
|||
| Line 3: | Line 3: | ||
In XLCubed you can easily convert an existing grid report to a formula report. | In XLCubed you can easily convert an existing grid report to a formula report. | ||
| − | To do this right-click on the grid, XLCubed | + | To do this right-click on the grid, then select the {{Menu|XLCubed|Convert to|Formula}} menu item as below: |
[[Image:con1.png|350px|centre]] | [[Image:con1.png|350px|centre]] | ||
| Line 11: | Line 11: | ||
[[Image:con2.png|350px|centre]] | [[Image:con2.png|350px|centre]] | ||
| − | If you are converting a grid report that contains | + | If you are converting a grid report that contains [[Dimension Slicers|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. |
[[Image:con3.png|350px|centre]] | [[Image:con3.png|350px|centre]] | ||
| Line 23: | Line 23: | ||
[[Image:con4.png|350px|centre]] | [[Image:con4.png|350px|centre]] | ||
| − | 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 | + | 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. |
[[Image:con5.png|350px|centre]] | [[Image:con5.png|350px|centre]] | ||
Revision as of 11:54, 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, then select the XLCubed > Convert to > Formula menu item 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.
