sum

[janardhan]

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

[er_mohit]

in your above question is  id and date are your dimension or not?

[janardhan]

dimensions only

[er_mohit]

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.