
Contributor III
2021-08-12
01:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculated Dimension
Hi All,
I am after some help with a calculated dimension.
In a straight table I want to display the name and sales qty of items that are graded as 'fast' for this week of sales only.
My dimensions are:
-Item Name
-Item Sales Speed
- Sales Week
- Sales qty
My current sales week is week 6.
Appreciate all help and suggestions.
Cheers,
Nick
414 Views
2 Replies


Partner - Master III
2021-08-12
03:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Something like this
aggr(if([Item Sales Speed]='Fast',[Item Name] & '-' & sum([Sales qty])),[Item Name])
392 Views

MVP
2021-08-12
05:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI @NickBentley
Try like below
Sum({<[Item Sales Speed]={'fast'}>}[Sales qty])
Based on ur week selection, it will display the sales qty with "fast" grade for the items
Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Please close the thread by marking correct answer & give likes if you like the post.
367 Views
