I want to show every month.

[Sxbbb]

I use code : 

Sum({<TypeStatus={'OUTER'},[Time - Month]= ,[Time - Day]= >} Aggr( Input_SQFT,WO_WorkOrderNo,[Time - Month]))

Result : 

Values ​​are displayed for only the selected month. But I want to show every month.

If selecting a month The value must still show every month.

What do I have to do?

[Mark_Little]

I believe that is because you have not include your set expression with the AGRR function to ignore your selections

[Sxbbb]

When I don't use Aggr, the value is incorrect. What do I have to do?

[MayilVahanan · Accepted solution]

Hi

Try like below

Sum({<TypeStatus={'OUTER'},[Time - Month]= ,[Time - Day]= >} Aggr( only({<TypeStatus={'OUTER'},[Time - Month]= ,[Time - Day]= >}Input_SQFT),WO_WorkOrderNo,[Time - Month]))

[Sxbbb]

thank you very much