1 Reply Latest reply on Oct 30, 2017 2:34 PM by Patrick A Van Der Hyde

    Create a fixed average that ignores filter and presents one value in chart

    Kylie Kaye

      Hello. I'm looking for some advice on how to create a fixed average (or other aggregate measure) that ignores a filter. I know you can create a fixed aggregate that works in table format (Calculate total ignoring filters ), but I want to be able to graph this so that the fixed aggregate measure (in this case, the average) appears as one value in the same chart (see below image).

       

      In the attached sample workbook, I've used the "state" dimension in a secondary data source ("Olympic States") as a filter on the "state" dimension in the Superstore data source. I want to be able to show how these Olympic States compare with the average of all states (and not just Olympic States) against the "Quantity" measure.

       

      Any ideas?