Issue with Pivot Data

[#1]

Hi Team,

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.

Need your help.

Thanks,

Sindhu.

[anbu1984]

Can you post sample app

[alexandros17]

Use NAme as dimension and 2 expression Sum(Hours), Sum(Job)

let me know

[jonathandienst]

Hi

Use Name as dimension, and Sum(Hours) and Sum(Jobs) for the expressions. Or have I missed something in your requirements.

HTH

Jonathan

[Anonymous]

Hi Sindhu

You need to remove the Dimension from the pivot chart insted of hiding it.

Regards

Harsha

[ashfaq_haseeb]

Is this what you are looking at?

Regards

ASHFAQ

[#7]

HI,

I have taken User as Dimension and and Sum(Hours) and Sum(Jobs) for the expressions as expressions.

Even I have removed Date dimension, but even then its not working.

Seems to be simple, but not able to produce in the required way.

Thanks,

Sindhu

[raviityou]

hi,

try this hope it will help you out

set Dimensions as Name (only)

even More:- try this

you can set  date on top site of the bar to show the value by date

and rest of all same (expression and all that thinks   )

[ashfaq_haseeb]

Did you check my application.

This is simple and straight forward.

have a look at attached image.

Regards

ASHFAQ

[#10]

Hi,

Sorry I didnt get the application.

Can you please resend it.

Thanks,

Sindhu.