Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You are correct... We dont need the {1}
Final code is aggr(sum( Total <Region> [Sd Net]),[Region],[Showroom])
Found the answer... aggr(sum({1} Total <Region> [Sd Net]),[Region],[Showroom])
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
sum(Net)
/
sum( TOTAL <Region> Net )
You are correct... We dont need the {1}
Final code is aggr(sum( Total <Region> [Sd Net]),[Region],[Showroom])