11 Replies Latest reply on Oct 16, 2016 4:45 PM by Vishal D

    Current Year - 1 - show sales as bar side by side based on quick filter

    Vishal D

      I have a Quick Filter - 'Report Year' = [2013,2014,2015,2016] from on a field in table from data source. I am displaying it in descending order and its a single value drop down.

       

      [Sales] is another field from database.

       

      So when you load the filter the default value will be '2016'

       

      What I want is if its '2016' then I want to show sales for '2016' current year and '2015' (current-1) as  side by side bar chart.

       

      If the user changes the filter to select '2015' then I want to show sales for '2015' current year and '2014' (current-1) as  side by side bar chart.

       

      Attached is sample twbx with some data.