nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Get another field1 of cube where MAX(field2)

Dunken

I have a simple cube like:
<pre class="_prettyXprint">
"Key" "Value"

AAA 1122
BBB 421</pre>
In my report I want to return:
<pre class="_prettyXprint">
AAA 1122</pre>
 --> because 1122 is MAX(Value)
 
I added a Summery Field with Function MAX and Expression dataSetRow["Value"]. However, how do I get access to Key AAA?
 
To me this is what I would get back in case I set a filter in an Excel table.

Find more posts tagged with

Comments

Dunken

Maybe to give a better example:
 
Let's assume I have the following table:
<pre class="_prettyXprint">
"Model" "Date" "Score"

AA 2015 5265
AA 2016 2145
BB 2012 6221</pre>
Now I would like to group on Model (works) and show the max Score (works with MAX(Score)). However, I also would like to show the Date of the max-Score:
<pre class="_prettyXprint">
"Model" "Date" "Max Score"

AA 2015 5265
BB 2012 6221</pre>
As mentioned in the original post I don't know how to add the Date where Score = MAX(Score)