Max(Column[AB) - Grouped by Column[A]

Hi,

the output of my dataset should be somthing like this...

A | B | C |
=========================
1 | 3 | 31 |
1 | 5 | 31 |
1 | 31 | 31 |
2 | 4 | 4 |
2 | 1 | 4 |
3 | 12 | 30 |
3 | 30 | 30 |

Col - A (month)
Col - B (day)
Col - C (checks the max(B) grouped by A)

I had the this or a similar issue severals times... is there any option to calculate a column like the col-C above?

Find more posts tagged with

Comments

fwhorton

I would think the answer is no. But, can you sort column b descending and then store first row into a variable for displaying? If not, can you create a select subquery to get the max value of column b?

mwilliams

Hi kik007,

I don't know that you'll be able to do this, at least not easily, within your dataSet editor, unless in your SQL. However, this is very simple to do for just display in your report. You'd create a table grouped by "month", sort the table on "date", and then add an aggregation over the month group with a function of MAX. This would display what you're wanting.

kik007

Hi,

thanks for your answers...

mwilliams, i will try it out and give feedback. Thanks

Hans_vd

Hi Kik007,

Where are you getting your data from?
If it is a database that supports analytical functions, it can easily be done in the SQL.