1 Reply Latest reply on Jan 24, 2019 11:32 AM by Patrick Van Der Hyde

    two trends same chart - one unfiltered not related with other

    firat.ada

      I have a table like that :

       

      parisperson12018125
      parisperson12018124
      parisperson12018113
      parisperson42018102
      newyorkperson52018102

       

       

      I want to show person sales trend and city sales trend in same chart. (may be one bar and another line with same chart)

       

      But the point is ;

       

      When I filter the chart with "person", the "city" sales are also filtered ( so both of them becomes the same result and trend)

       

      The thing I want is, when I filter person 1, I want to see the person 1 trend with bar and also the Paris trend (unfiltered!) with line.

       

      Is there a way to do this? With calculated field etc?

       

      Thank You!