I have my entire table in the Get Data option. There is data from multple users (their total spend). However I want to show the information in column of just the selected user. I dont however want to show all the data and then the selected users data as the highlighted portion. The whole graph should only relate to the given user.
I have created the graphs, have created the table to select the user I want but when the user is selected the column turns transparent and the users information (column X axis is the years) shows as just the highlighted portion of the total column. I dont want the user to see the total spend of all users, just the selected one.
Is this possible? Or do I need to manipulate the entry data from the table and ony select for the given user?