XFCELL - Can we use member filter ?

OS_Pizza
Contributor III

1.How can we use the below member filter in red colour inside XFCELL. How can we use it?

XFCell(Cb#GolfStream:E#[NA Clubs]:C#USD:S#Actual:T#2022M1:V#YTD:A#69000:F#None:O#Top:I#Top:U1#Top.base.where(Text2 contains '|WFYear|'):U2#Top:U3#Top:U4#Top:U5#None:U6#None:U7#None:U8#None)

2. How can we use GetDataCell(A#A100+A#200) inside XFCELL to calculate some expression.

 

Thank you!!!

1 REPLY 1

JackLacava
Honored Contributor

XFCell is only able to retrieve one cell at a time, given a precise POV; you cannot use expansions there, nor calculations. If you want to use expansions and calculations, you need a Cube View. Have a look at the section "Presenting Data With Extensible Documents" in the Design and Document Guide (or search for it in online Help) for how to embed CVs in Extensible Documents including Excel.