I had come across a scenario where I have data in my qv report (pivot table) as below:
Date
Name
Hours
Jobs
54.65
33
13/11/2014
A
7.5
5
13/11/2014
B
4.7
3
13/11/2014
C
5.5
2
12/11/2014
A
7.5
1
12/11/2014
C
7.0
6
11/11/2014
B
6.5
4
11/11/2014
C
3.75
8
10/11/2014
A
4.7
3
10/11/2014
B
7.5
1
Now, I want a report which displays data in a following way, as below:
Name
Hours
Jobs
A
19.7
9
B
18.7
8
C
16.25
16
I have tried couple of options like I have taken the 'Date' Dimension then in the Presentation Tab I selected Hide Column, but the results are incorrect.
That is what the required output should be, but there is a problem that hours and jobs I'm pulling from a different DB's where there is no common field to link them. To associate them I have one excel file as an interface. But without the session dates I'll not be able to get the correct hours.
