110
Hi,
I have an account format where the last two segments are lengths of 3 and 2. For example, I may have 2LL-QS and 2LL-XL. I want two columns to restrict by these. However; it seems like it takes and 'or' instead of an 'and'. If I have '+Facility = [2LL] +Type = [QS]' I get all accounts with QS as the last segment.
Can I restrict a column using more than one of the account segments?
thx,
Doug
*This post is locked for comments
Hi Matt,
Than ks for the reply. I did try that, but it didn't quite work. If the accounts with both segments exist it does work. For example, if 2LL-QS exists it will display in the column. However; if it does not exist it sometimesseems to flip to an 'or' and displays all results with QS in the account. I think it may be that if no transactions have occurred for that segment combination it flips to the or.
I can have the first segment restriction in the column and separate tree branches for QS, but that will be an issue if I need more detailed column filtering on other reports.
For some columns it does work so I will keep digging to see if I notice anything. At this point, it feels like a bug or I may need to 'rebuild the data mart'....again! lol
You actually want a comma in between them instead of a +.
So +Facility = [2LL], Type = [QS] instead of +Facility = [2LL] +Type = [QS]
If you double click in the Dimension filter field and add your dimensions there it will build the formula for you.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (