Skip to Content
0
Former Member
Mar 04, 2015 at 09:48 AM

Displaying Date

16 Views

Hi All Experts!

I have got in trouble to display date dimension. As you seen from below, I have two tables and I would like to show date that has to be matched related amount.

The report is based on single universe, one query and there is no more complex structure.

My current table:

Line DATE AMOUNT 1 01.03.2015 30 1 02.03.2015 50 1 03.03.2015 10 2 01.02.2015 20 2 02.02.2015 40 2 03.03.2015

5

I would like to get this table:

Line DATE MAX AMOUNT 1 01.03.2015 50 2 02.02.2015 40

any help would be appreciated!