CUBE formula to show member name based on member code

Occasional Visitor

Hello everyone, 

 

I would like to ask for some help with CUBE formulas.

 

I am dealing with a CUBE where I have multiple members with multiple properties.

 

Below there is a Pivot built on the CUBE and I have the account code (Natural Code) and to each account is assigned a name (Natural name), multiple Groups and Groups Names....

 

Would you be able to help me with a CUBE formula to show the Natural name based on the Natural code?

 

For example, for the first line, I would like to have a formula that would show me Group 3 "Volume Discount" based on the Natural code 94997.

 

Colombino89_0-1658129627806.png

 

I have been looking around for this and tried CUBEMEMBER formulas, but I don't seem to manage to make it work!

 

Thanks a lot for the help!

0 Replies