Forum Discussion

OS_Pizza's avatar
OS_Pizza
Contributor III
3 years ago

XFCELL - Can we use member filter ?

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!!!

Excel Add In
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    3 years ago

    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.