5 Replies Latest reply on Feb 15, 2016 10:37 AM by Shinichiro Murakami

    creating filtered and unfiltered components of a view through data duplication/ relationship modification



      I am attempting to create a dual axis chart with a filtered and unfiltered component through the method suggested my michel cassie in the following thread: Can i have a Dual axis chart but with a filter applied only on one?


      In the attached example workbook, I have attempted to remove the department relationship between the original and duplicate data sets in order to enable filtering the bars (original data) by department while leaving the line representing moving average of profits of all departments (duplicate data) unfiltered. However, filtering still affects the moving average.


      Would anyone be able to take a look and offer any suggestions as to why I have not succeeded in producing a moving average line that is not affected by a department filter?


      Many thanks,



      Michel Caissie