Issue in creating Asymmetric view

Yash1

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 ?

  

Thanks,

Yash

 

Book2_79997.xlsx

Misbah

@Yash1 

 

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.