on 10-16-2015 7:25 PM
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
Hi, is [hours] a measure object ? Have you Avoid duplicate row aggregation unchecked in Table properties
Regards,
Rogerio
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.