I created a dashboard in Excel by using the SAP Analysis for Office. This dashboard is used by end-users that don’t know anything about Analysis for Office.
They want to filter data by Material Number, but the “Filter” option in the “Analysis Design” tab doesn’t meet their need. Because sometimes they want to filter data by using the asterisk (*).
I know that we can use an alternative way, and it is using the "Filter by Member" or "Background Filter", but the problem with these two solutions is that the first one needs crosstab to right-click on its dimensions and choose “Filter by Member” option or select the “Filter by Member” from Analysis tab, and in the second one the end-user must go to “Design Panel” and use the “Background Filter”.
Note that my dashboard doesn't have any crosstab, indeed the crosstab is in a hidden tab in excel and the end-users just see the charts. When they filter the data by Material Number, they see the charts that related to that Material Numbers.
Is there any way to filter data by wildcard using the “Filter” option in the “Analysis Design”?
Thanks in advance,