1 Reply Latest reply on Apr 9, 2013 11:50 PM by Prashant Sharma

    Action Filter to compare against overall total

    Alan Kwan

      Hi all,

       

      I have a sheet of names (sheet 1), and a sheet of line chart by sales over time (sheet 2). Sheet 1 has an action filter, when a name is selected, sheet 2 will only show the sales for the specific name. Here comes the question, is it possible to to have sheet 2 show the Total Sales (all names summed up) as 1 line, and the selected agent as another line?

       

      I have tried duplicating the data source (which makes my .twb file size much bigger), so I am wondering if there are any other ways of achieving this? Can a calculated field do this?

       

      Thanks,

      Alan