Skip to Content
avatar image
Former Member

WebI Crosstab report functionality issue?

Hi All,

I have an issue with webi crosstab report, Report has just 3 objects like name, date and hours. Currently report looks like this,

           10/16/2015    10/17/2015   10/18/2015  10/19/2015   Total

Name

A               10                                                                    10

A                                 15                                                  15

A                                                     20                               20

B                                 25                                    35           60

B               15                                  15                               30

C                                                    45                               45                

                                                                                      ----------

                                                                                        180

I want report like below,

              10/16/2015  10/17/2015   10/18/2015  10/19/2015    Total

Name    

A                 10              15                  20               -             45

B                15               25                  15             35            90

C                  -                     -               45                             45                              

                                                                                         -------

                                                                                          180

Basically I want to display data in one row instead of multiple rows.

Not sure it is kind of simple but tried in different ways, didn't find the solution.

Any suggestions would be appreciated.

Thanks,

Venkat

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 16, 2015 at 07:25 PM

    Hi, is [hours] a measure object ? Have you Avoid duplicate row aggregation unchecked in Table properties

    Regards,

    Rogerio

    Add comment
    10|10000 characters needed characters exceeded