AnsweredAssumed Answered

Portals Relating to the same Field

Question asked by JackSaward on Nov 25, 2015
Latest reply on Nov 25, 2015 by PeterDoern

Hi All -

 

I am trying to get a rolling 12 Month 'chart' of portals showing information on scrap. Like this: Previous.JPG

 

I have created summary fields for each fault in a separate table, I am trying to create a portal for each month column, which will show this summarized data. Each month has a unique ID to create the relationship, this is in number format i.e, 1, 2, 3... However I can only get the portals to show the 'current months relationship' Is there a filter expression I can use to make other portals show subsequent months?

 

layout.JPG

Relationship.jpg

Bearing Housing scrap monthly totals & test quality report are the tables in hand here.

 

Thanks I appreciate any help.

Outcomes