Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends ,
I have an issue with sum
Eg.,
ID Date Type Hours
11 01/03/2012 Normal 8
04/05/2012 Normal 10
12 01/06/2012 Norm 12
01/07/2012 Normal 22
13 01/02/2012 Normal 24
02/05/2012 Normal 44
-------------------------------------------------------
total 120
--------------------------------------------------------
My requirement is above like that
but i am getting that
ID Date Type Hours
11 01/03/2012 Normal 20
04/05/2012 Normal
12 01/06/2012 Norm 34
01/07/2012 Normal
13 01/02/2012 Normal 68
02/05/2012 Normal
I need to display all the respected values
Thanks
in your above question is id and date are your dimension or not?
dimensions only
ok.
in presentation tab of your pivot table you just click on partial sum of field name date corresponding and in expression write sum of that field
then it will comes like you want
hope this will helps you.