Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Tags:
Former Member
Former Member replied

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

Regards,

Rogerio

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question