Running of total sum value in measures regardless of the selection

[Vince_CH]

Hello All,

I have a table like below, with sales being the total service income, and machine & machine value are the machine qty and value each customer has.  I intend to have the service income selected by the year, and the machine qty  and value kept in total regardless of the selection.  My expressions for machine qty like following, but when I selected by certain year, the machine qty turns zeor, with actual total should 8 instead.  How can I do it?   thanks in advance!

Sum({<[Order Type]={'Y470','Y471'}, Order_Group_Text={'machines'}, [Material Number]-={ 'TANK'}>}
Aggr(Order_Item_Quantity,[Order No.],[Item Number]))

[uacg0009]

Hi,
Do you mean you want to ignore the Year selections?
if yes, please add [Year]= into your set analysis.
Aiolos Zhao

[pradosh_thakur]

Sum(total<year>  {<[Order Type]={'Y470','Y471'}, Order_Group_Text={'machines'}, [Material Number]-={ 'TANK'}>}
Aggr(Order_Item_Quantity,[Order No.],[Item Number]))

[pradosh_thakur]

Sum({<[Order Type]={'Y470','Y471'}, Order_Group_Text={'machines'}, [Material Number]-={ 'TANK'},Year = >}
Aggr(Order_Item_Quantity,[Order No.],[Item Number]))

[Vince_CH]

Gents, thanks for replies. I have tried following earlier, but when I selected certain fiscalyear, the result is zero still.

Sum({<[Order Type]={'Y470','Y471'}, Order_Group_Text={'machines'}, [Material Number]-={ 'TANK'},FiscalYear = >}Aggr(Order_Item_Quantity,[Order No.],[Item Number]))

[pradosh_thakur]

You tried this as well.

Sum(total<year>  {<[Order Type]={'Y470','Y471'}, Order_Group_Text={'machines'}, [Material Number]-={ 'TANK'}>}
Aggr(Order_Item_Quantity,[Order No.],[Item Number]))