Hello
in a matrix report I've got column grouping, in each group there are 4 columns, now one of the columns(date column) I want it to show once but its showing 4 times. I do understand its because on the database its written 5 times , but is there a way to remove or hide away the other dates?
e.g on the database
date | seq | Name | amount
13/01/2013 1 marketing 100
13/01/2013 2 Progr 200
13/01/2013 3 Client 500
13/01/2013 4 Lead 700
Now the output must be
date |marketing | Progr | Client | Lead
13/01/2013 100 200 500 700
but it shows the date like this
date |marketing | date | Progr |date | Client | Lead
13/01/2013 100 13/01/2013 200 13/01/2013 500 700
How can I do this?
🙁
some help will be much appreciated.
Regards