A new release of the Smart View Toolkit, version 1.015, is available. Click here to obtain the latest release. We have added the following new functionality:
- Added “Convert HsGetValue to Ad Hoc” feature
- Added “Adjust Column Width” Quick Option
- Miscellaneous performance improvements
Convert HsGetValue to Ad Hoc Analysis Mode
If you utilize reports based on HsGetValue, you will want to check out the new feature “Convert HsGetValue to Ad Hoc”. As the name implies, you can use it to convert an HsGetValue formula into an Ad Hoc Analysis grid.
First, select a cell that contains an HsGetValue formula.
Second, in the ribbon go to ‘VBA Functions’ > ‘Convert HsGetValue to Ad Hoc’.
A new sheet “AdHoc” will be created with an Ad Hoc Analysis grid. You can then Zoom In, Pivot, etc. in order to perform further analysis.
Hopefully you find this feature helpful. We welcome and appreciate your feedback and will incorporate new ideas wherever possible.