Hello All! Can you create a Timesheet report with a cross table to show the Expense Type (Capex / Opex) by week for a month? Thanks
Solved
How to create a cross-tab report that uses Time-Phased data to show the Expense type (Capex/Opex) by week/month?
Best answer by DrewMiddleton
I suspect you’re talking about a cross-tab report that uses Time Phased data. The crazy thing is that Timesheets are not actually time phased data themselves, but they do generate time phase labor data. So you might want to try writing your report using Work Item as the primary object, and then Labor Time Phased Data as the second. If you group by ID, you can use Expense Type as a Leading Column, or you can include the Task Assignment Capex / Task Assignment Opex columns in the Crosstab Columns.
+2I suspect you’re talking about a cross-tab report that uses Time Phased data. The crazy thing is that Timesheets are not actually time phased data themselves, but they do generate time phase labor data. So you might want to try writing your report using Work Item as the primary object, and then Labor Time Phased Data as the second. If you group by ID, you can use Expense Type as a Leading Column, or you can include the Task Assignment Capex / Task Assignment Opex columns in the Crosstab Columns.
Reply
Most helpful members this week
Planview Customer Community
Already have an account? Login
Planview Customer Community
No account yet? Create an account
Login with SSO
Login with Planview Adminor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
All Data Subject Access Requests (DSARs), and requests of “Do Not Sell My Personal Information” according to the CCPA, must be submitted through the Planview DSAR portal located here
Planview has appointed a Data Privacy Officer (DPO) to be responsible for overseeing our Privacy Management Program and related privacy compliance measures. DPO can be contacted at privacy@planview.com
Planview has appointed a Data Privacy Officer (DPO) to be responsible for overseeing our Privacy Management Program and related privacy compliance measures. DPO can be contacted at privacy@planview.com