Can you post sample workbook with Dummy data !
Here you go.
I also noticed that when I create my calculated field to filter on, it puts it down in Measures...when I would ordinarily expect my filter calcs to be in Dimensions.
Either way, even when using Superstore and an Excel file, I can't get it to do what I am trying to do.
2 of 2 people found this helpful
Yes, you can use parameters to filter across data sources as you can see here, but to use this technique you have to create a parameter based on the PIN (which is the common field of those two data sources) and you would have to exclude the aggregation from your calculation. So it would be PINParameter = PIN (Excel data source).
The problem with your current calculation is that you are having * as the return of your calc and the get rid of it, you have to have PIN on your detail. You can have a look here to better understand what I mean.
Still, I think you should try the cross database join functionality. You can have great benefits to have only one data source and even more if you make an extract of it.
I hope that helps.
Oh believe me, if our enterprise was ready to go with 10.0 I'd be more than happy to use the cross-database joins. But that'll have to wait a month unfortunately.
I've used parameters to filter across multiple datasets before, but never a blended dataset like this. What we want our end users to be able to do is select a team name and have the data only show the people who are on that team. So creating a parameter based on PIN won't give me the end user experience we are looking for...unless I'm misunderstanding you.
1 of 1 people found this helpful
Actually, for your use case, it works like a charm... Just follow these steps:
- Create a new calculated field on the "Sheet1 (faketeamnames)" data source with the calculation [Team Name Parameter]=[Team Name].
- Put this new calculated field on the Filters Shelf and choose select All Values.
- Mark just true values
- Now you are good to go :-)
Thank you both for your help. For some reason, I am unable to drag the filter calc to the filter shelf regardless of which datasource I have the calculation in. It is grayed out and has the little circle with the slash through it indicating I cannot place the calc on the filter shelf.
Would it matter that I am in 9.1?
i think it will not be the problem with 9.1 version, I tried similar thing in 9.2 version some time back.
Yeap, no problem in doing that on version 9.1.