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?
Create a parameter and then create a calculated field in which compare the values of parameter and the Dimension you are using. I think this will help you. I will do some calculation if you will provide me some sample data and also provide me what you done till yet.