Calculated Dimension

[NickBentley]

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

[lironbaram]

Something like this 

aggr(if([Item Sales Speed]='Fast',[Item Name] & '-' & sum([Sales qty])),[Item Name])

[MayilVahanan]

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