I have 3 lists :
1 - L3 Project
2 - Project Name
3 - Project Manager.
I want to create a module with Dimensions - L3 Project, Time and Lineitems (or Line item subset) to show project name and Project Manager along with L3 Project without time whereas the line items (Cost, Revenue, Invoice) are with time.
Any suggestions ?
Create a LIS.
Use LIS, Project and Time as a dimension in your module.Line items & Time in columns, LIS in Pages and Projects in Rows
Create one Line item (L1 )to fetch the data and two more line items (L2 & L3) to get the parents of the projects
Keep only Project as a dimension in latter two line items (making these as subsidiary views)
Use Hide or Show on L2 & L3 line items to create a desired view.
Note: This is not at all scalable because as and when new year gets added to the timescale your view needs to be modified and send to the Production environment.