Mavericks334
Active Member
- Joined
- Jan 26, 2011
- Messages
- 280
Hi,
I created a Powerpivot, which gives me the list of all the names of the employes and in the values filed gives me the time spent.
There are few employees names which are reflecting as blank values in the row's filed,
When i click to see the names of these employees it reflects in the data[TABLE="width: 244"]
<COLGROUP><COL style="WIDTH: 173pt; mso-width-source: userset; mso-width-alt: 8411" width=230><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><TBODY>[TR]
[TD="width: 230, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 95, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Site[/TD]
[TD]Funds Per Day[/TD]
[/TR]
[TR]
[TD="class: xl66"]HYD[/TD]
[TD="class: xl69"]1255.570316[/TD]
[/TR]
[TR]
[TD="class: xl66"]POZ[/TD]
[TD="class: xl69"]573.4869561[/TD]
[/TR]
[TR]
[TD="class: xl66"]TOR[/TD]
[TD="class: xl69"]119.2113041[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]37.67848065[/TD]
[/TR]
[TR]
[TD="class: xl67"][/TD]
[TD="class: xl69"]37.67848065[/TD]
[/TR]
[TR]
[TD="class: xl68"][/TD]
[TD="class: xl69"]37.67848065[/TD]
[/TR]
[TR]
[TD="class: xl66"]Grand Total[/TD]
[TD="class: xl69"]1926.302799[/TD]
[/TR]
</TBODY>[/TABLE]
These employees reflect in the employee table because their names already show up in the above details.
Only a selected values are not reflecting, can any suggest wat needs to be done.
I created a Powerpivot, which gives me the list of all the names of the employes and in the values filed gives me the time spent.
There are few employees names which are reflecting as blank values in the row's filed,
When i click to see the names of these employees it reflects in the data[TABLE="width: 244"]
<COLGROUP><COL style="WIDTH: 173pt; mso-width-source: userset; mso-width-alt: 8411" width=230><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><TBODY>[TR]
[TD="width: 230, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 95, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD]Site[/TD]
[TD]Funds Per Day[/TD]
[/TR]
[TR]
[TD="class: xl66"]HYD[/TD]
[TD="class: xl69"]1255.570316[/TD]
[/TR]
[TR]
[TD="class: xl66"]POZ[/TD]
[TD="class: xl69"]573.4869561[/TD]
[/TR]
[TR]
[TD="class: xl66"]TOR[/TD]
[TD="class: xl69"]119.2113041[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]37.67848065[/TD]
[/TR]
[TR]
[TD="class: xl67"][/TD]
[TD="class: xl69"]37.67848065[/TD]
[/TR]
[TR]
[TD="class: xl68"][/TD]
[TD="class: xl69"]37.67848065[/TD]
[/TR]
[TR]
[TD="class: xl66"]Grand Total[/TD]
[TD="class: xl69"]1926.302799[/TD]
[/TR]
</TBODY>[/TABLE]
These employees reflect in the employee table because their names already show up in the above details.
Only a selected values are not reflecting, can any suggest wat needs to be done.