Get region contribution for stores

[#1]

Hi, I looking for a solution to get region sales next to respective store.

In the attachment the table marked with green square has showroom name and sum of Net sales. I need to get the region sales for respective stores which would help me understand % contribution to region.

Region is 1 level up in hierarchy which is present in Showroom attributes table marked in red square.

Please can someone help me resolve this.

Thanks

Sujay

[#2]

Found the answer... aggr(sum({1} Total <Region> [Sd Net]),[Region],[Showroom])

[kkkumar82]

Hi Sujay,

Do you really require {1} check that once as it won't accept any selections , if it is fine close your ticket by pressing

correct answer in actions so that it may help to some others

[agigliotti]

sum(Net)

/

sum( TOTAL <Region> Net )

[#5 · Accepted solution]

You are correct... We dont need the {1}

Final code is aggr(sum( Total <Region> [Sd Net]),[Region],[Showroom])