In a report, I'd like to compare the current detail row value against the max value for the column. It seems that max is <N/A> in detail rows. Any suggestions on how I can indicate which row is has the max value?
Reporting is a separate module to Perspective so the problem isn't a Perspective one. I removed the tag and I'll delete this post later.
I'm assuming you're using the 'max' aggregate key in the report table? As far as I know that only works in the summary section at the bottom of the table, not in a detail row.
If you want to know the row number that contains the max value, you might need to add an additional script data source and put some logic there to find this out and add it to your dataset.
3 Likes
Ya, that's what I was afraid of...thanks.
Get the SQL query to do that donkey work for you.
Share your query and we'll figure out a solution.
Here's an example I created for you on SQL Fiddle.