Calculate the formula only for the same sub

[Anonymous]

Hello,

please find attached this table.

I want to show as you can see here the data two subsidiaries ess spain and nexo but i noticed that cumul sales works correctly only if want to show the data of one subsidiary. What i want exaclty is to apply the cumul sales formula only if it is the same subsidiary name.

This is the formula of cumul sales: RangeSum(Above(TOTAL ([Actual Sales]), 0, RowNo(TOTAL)))

Thanks for your help!!!

Alâa Eddine.

[sunny_talwar]

Try this

Aggr(RangeSum(Above([Actual Sales], 0, RowNo())), Subsidiary, YearMonth)

[Anonymous]

Hello, sorry but it does not work. Do you have any other idea?

Thank you.

Alâa Eddine.

[Anonymous]

Hello, sorry but it does not work. Do you have any other idea?

Thank you.

Alâa Eddine.

Re: Calculate the formula only for the same sub

[sunny_talwar]

Did you use the correct field names within the Aggr function?

Aggr(RangeSum(Above([Actual Sales], 0, RowNo())), Subsidiary, YearMonth)

Also, I noticed that you have a cyclic group for your second dimension.... where you on Subsidiary dimension when you looked at the chart?

It might help if you are able to share a sample to look at

[Anonymous]

Hello,

thank you for responding.

i really do not know how to share the chart but i applied your formula and it works but not like i want.

thanks,

Alâa Eddine.

[sunny_talwar]

Not the chart, but the app

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample