range sum of object

[zied_ahmed1]

Hello Everybody,

I need to do range for this object :

For example i have a bar char with these date , I need to do the sum of these object like in the photos (In 2021-03 i will have 46 (3+7+36) 

Thanks 

[zied_ahmed1]

Hello I have 2 dimensions i used this set analysis but in 2021-10 and 2021 the value is not ok : 

Aggr(
RangeSum(Above(
Count({<New_Category={"IV1/IV2 -A"}>}[Application Services name])
, 0, RowNo()))
, Envirement, (Migration_date,NUMERIC, ASCENDING))

Any ideas please 

[Chanty4u]

try now

Aggr(RangeSum(Above(Count({$<New_Category={"IV1/IV2 -A"}>}[Application Services name])
, 0, RowNo())), Envirement, Migration_date,NUMERIC, ASCENDING)

[zied_ahmed1]

Thank you but it doesn't work 😕 

[zied_ahmed1]

@sunny_talwar 

[Chanty4u]

may be any one of it

Aggr(RangeSum(Above(Count({<New_Category={"IV1/IV2 -A"}>}[Application Services name])
, 0, RowNo()))
, Envirement, (Migration_date,(NUMERIC), ASCENDING))

or

aggr(rangesum(above((Count({<New_Category={"IV1/IV2 -A"}>}[Application Services name]),0,RowNo())),SecondDim,FirstDim)

[zied_ahmed1]

Thank you but it doesn't work with these two set analysis 

[Chanty4u]

can you attach sample? 

one sample i attached check that aswell