When I try to open it up, I am asked for a database sign-in. Could you embed these credentials or a mockup of the data, so that we can take a look at it?
You can only "Apply to" the same data source. You have different data sources.
Create three PARAMATERs. (Assuming the same values are in all 3 data sources) use the parameters to create calc filters.
Only problem with that is that parameters can only have a single value. So if you are looking for multi-value selections, that won't work either.
As you are using three different data sources quick filter wont work in this case, you need to use parameter to reflect in all sheets.
This isn't entirely true, Joe. While not very dynamic, it is possible to have an "All" type option in a parameter list. Credit to Ben Sullins for this one, which saved me a good headache back when I found it!
I'm using the Superstore data set, and I put together a worksheet in which I have SUM(Sales) on the columns shelf and Order ID on the Rows shelf. I want to use a parameter list to choose which order I want to look at, so I created a parameter called "Order Selection"; a list of String parameters populated by the field Order ID. I added an additional parameter to the bottom of this list with a value and display of "All", then moved it to the top of the list.
Since we can't filter based on a parameter, I put Order ID on the filters shelf and went in to edit it. On the General tab I said to "Use All", then on the Condition tab I selected By Formula and entered the following formula:
IFNULL([Order ID],'Null') = IF [Order Selection] != 'All' THEN [Order Selection] ELSE IFNULL([Order ID],'Null') END
Drag Sales onto Label, change the mark type to Bar, a few formatting changes and voila! A parameter list with a functional "All" option.
Here's what it looks like:
Vincent -- There still is only one value in the parameter though.
Yes, you can have an "ALL" choice in your parameter list, and then just make a calc that does:
[Parameter choice] = "ALL" or
[field name] = [Parameter choice]
... put that on the filter shelf and then select for True in the filter.
But "ALL" is still just one value. You're just treating it specially.
In the Working.twbx example provided I noticed that one of the filters was "exclude" for certain items. Not all. And not just one. That one might have to be added to each data source separately.
Thanks for the clarification, Joe. I'm still trying to wrap my brain around the limitations of parameters (at least until 10.0 rolls out, with the "Apply to All Related Data Sources" feature). Since Corey appears to have the "GL Account No" common to all 3 data sources, couldn't he just use one parameter based on that list? 3 separate calculations (1 to filter each data source), but all tied to the same single parameter?
Vincent -- That was precisely what I was describing. Three calcs, one in each data source, playing off the single parameter. The only drawback is if he wants two or 3 items selected, not just one. (Or not "ALL".) parameters will only hold one value at a time.