Hi all
I really hope you can help with this issue as it is driving me qrazy.
I have build a really nice PowerPivot model and I am now in the process of setting up an end user friendly excel report in which I use cube formulas.
I normally create a suitable pivottable and then convert it to cube formulas before replacing the elements with cell references.
However when my pivottable have more levels, the converted cube formula contains on or several \ (backslash), which has the effect that the use of cell reference dont work.
I haven't found a work around so far.
Please HELP!
Br Exceldoktor
I really hope you can help with this issue as it is driving me qrazy.
I have build a really nice PowerPivot model and I am now in the process of setting up an end user friendly excel report in which I use cube formulas.
I normally create a suitable pivottable and then convert it to cube formulas before replacing the elements with cell references.
However when my pivottable have more levels, the converted cube formula contains on or several \ (backslash), which has the effect that the use of cell reference dont work.
I haven't found a work around so far.
Please HELP!
Br Exceldoktor
