I have a problem trying to aggregate an element in my Measure dimension using Max criteria.
Here is my cube and what i wanted to do (the image are an Excel representation of what i see in Cube Viewer):
The concept is that for every node in the dimension measure on the element "Std. Cost" i want to have on the consolidated element the max of the children below.
At the moment i implemented this formula:
Code: Select all
['Std. Cost' ] = C:ConsolidatedMax(0,'',!Warehouse,'Std. Cost');
Any advice? I searched a lot on this forum and around and also tried a lot with Rule but everything was unsuccesseful
Thanks in advance,
Leonardo