WebI Crosstab report functionality issue?

[Former Member]

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

[Former Member · Accepted solution]

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

Regards,

Rogerio