8 Replies Latest reply on Feb 25, 2015 11:47 AM by hannah.johnson

    Filter out data in chart from only 1 of 2 sources

    Madeline Coyne

      In the attached workbook I need to filter out "actual" data but still show "planned" data. I only want to show January real data but since the database is a server and updated weekly I cannot just refresh on the end of a month. I also want to still show an entire year of planned data in the same view.

       

      I think this can be done with a parameter but not sure how to do that. Also if there is a way to automate the parameter data that would be great because there are over 15 graphs similar to this in the report.

       

      Thanks!