Nprinting pivot table in loop

[Anonymous]

Hi ,

The challenge I have here is to plot multiple line chart with straight table underneath in Nprinting.

The approach I used  is to bring the straight table in NPrinting by using Level,  and then create an pivot table on top of this table , and then the pivot line chart on top of the pivot chart.

The approach works for the first portfolio,  however once I put page function on the portfolio field to loop through and generate this chart for each  portfolio. It breaks and all the charts are pointing the data source from first portfolio page and showing the same chart.  The straight table’s data fresh with different portfolio,  however the pivot table and chart do not.

Is there other approach I can use here to fix this problem?

Really appreciate your advice here.

Regards,

Wen