7 Replies Latest reply on Aug 21, 2013 7:09 AM by Pedro Machado

    Combine a chart with single data based on filter and the aggregate without filter

    Markus Ekenberg

      So I have data which includes different countries and different categories and what I want to do is to create a bar chart with two bars. The first bar contains the filtered data on both country and category. The second should should only be filtered on the category filter so that I can compare the individual country against all countries based on the category filter. I should add that I have quiet a few countries and categories in the filters to choose from.

       

      Any ideas on how to solve the problem? Is there a way to create a calculated field that ignores a filter?

       

      Best,

      Markus