XFGetCell Formula Question
When building CubeViews there is the .remove string that you can use to exclude a member from a hierarchy that you are pulling. Is there a way to replicate this with =XFGetCell formulas? Or in genera...
Forum Discussion
Not within a single XFGetCell but you can combine them in Excel formulas e.g.
image.png1163×235 10.1 KB
To add to Lee’s suggestion, you could also pull a parent then subtract a base member or two if that’s an easier way to get to your solution.
The XFGetCell is pulling one specific intersection as opposed to the member filters used elsewhere so it’s a little more limited.