Forum Discussion

CWin's avatar
CWin
New Contributor II
11 months ago

Quick View - Reference cell for parameter

Is there a way to have the time POV reference a cell (A1) in a spreadsheet?  User wants to have multiple Quick Views and change time once in cell A1 and it update all Quick Views in the workbook.
Excel Add In
CWin's avatar
CWin
New Contributor II

Thanks, Ben --- They want to use the dynamic function of the quick view so if a new account / entity is used it will show in their reports.  

MikeG's avatar
MikeG
Contributor III
11 months ago

Hi CWin you would need to convert the Quick View or embedded Cube View to an XFGetCell() retrieve report.  Then you can do what BenThompson noted and have a Cell Reference to the T#.  

You can't embed a Cell Reference into a Quick View.  At least not that I'm aware of.

Hope this helps,