Cubevalue question: can it be lookup wildcards *

[jccnz]

Hi,
such as sumif/sumifs function we can sum the value with * such as Sumifs(A:A,B:B,"xy*")
is seem like cubevalue cannot use *, anyone can help?
Thanks

 

[jorismoerings]

Hi,

2 possible options:

1. If you want to do it without measures: create the data set "xy*" using the CUBESET function which does allow wildcards and use that in CUBEVALUE; or
2. the more easier one; just create a separate measure in your data using the wildcard in the filter and use the separate measure in CUBEVALUE

 

[jccnz]

thanks, I get it