I have a set of data that I need to have a value in two different columns, but when I set a filter on the sheet it filters the entire sheet. Sorry if this is a simple fix, I'm new to the software. Alternatively how could I pull data from one sheet to another, that way I could use the filter there and then be able to use the data in the new sheet. *
I really should start proofreading stuff
1 of 1 people found this helpful
Hi T C, could you show a detail of what you are expecting?
How many connections you have? You could probably create two sheets, each one with each measure and add the filter you want to use to only one of the sheets, next in the dashboard, you use the filter only applying to the sheet that you want..
I only have one connection, I have tried two sheets to get the data I want, but I need to be able to use a calculated field with both the pre and post filtered data together. if that makes sense.
I have measures/rows a,b,c and d (all with a filter) and I need to be able to do stuff like [d / (2nd)filtered b] and [b / (2nd)filtered b] as new measures/rows. Is that possible on the dashboard?