Matrix report - a column showing more than once

  • 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

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply