Dynamic Reference of Slicer in Cubevalue function
Hello everyone,
TLDR - just read "The problem"
I have a tab with lots of Cubevalue formulas and several slicers (slicer_tab1_slicer1, slicer_tab1_slicer2 etc.). Now I want to copy-paste this tab a few times. When I do so, my cubevalue formula still contains the references to the tab1 slicers, instead of the new tab2 slicers.
My idea is to create a small list on top of every tab saying: "References to the slicers in this tab that should be used in the formulas": "slicer_tabx_slicer1", .... So instead of changing all the formulas, I reference this small list in my formula. And when I copy-paste my tab, I just need to read out the correct formula names of my new slicers, change the list "references to the slicers in this tab that should be used in the formulas", and all formulas work perfectly.
The problem: Cubefunction does not seem to read references for slicers when they are stored in a field. So if i have a function =CUBEVALUE(Datamodel, bla, bla, bla, Slicer_tabx_slicer1) it works, but when I write =CUBEVALUE(Datamodel, bla, bla, bla, A3) and A3=Slicer_tabx_slicer1 it doesn't work.
How can I solve this? Thanks in advance!
PS: It's excel 365...
[link] [comments]
Want to read more?
Check out the full article on the original site