2 Replies Latest reply on Jul 10, 2017 9:03 AM by Luke Sirakos

    Excluding a filter on a line graph?

    Luke Sirakos

      I am using the super store data for this example, say I want to create a line graph that shows the sales over time for a sub-category and then compare it to the average sales for all different sub-category groups in that category.  I create one line graph that filters on sub-category Tables in the Furniture category.  I create another line graph just filtered on Furniture using a LOD calc to find the average across each subcategory. How can I put both of these lines on the same graph when the first has a restrictive filter? Is there a way to make the LOD calc ignore the filter?

       

      Example workbook included.