Need help in expression. Region sales for managers

[#1]

Hello!

There is a table with three columns.

LOAD * INLINE [

region, pers, sales

1, 1, 11

1, 2, 12

2, 3, 23

2, 4, 24

];

And there is a chart with dimension "pers" and expression sum(sales)

Need second expression with region sales for persons.

The answer for first and second person is 11+12=23, for third and fourth person is 23+24=47

What QV function can help me?

[#2]

hi

see this attachment

thanks

Zaman

[#3]

Thanks, Zaman, but need another thing.

I added hardcode to my example in original post. That is our chart.

Our chart shall contain one dimension and two expression

[boorgura]

You can achieve that by having 2 dimensions:

Region and Person

And expression will be:

Sum(Sales)

Sum(all <region> Sales)

Let me know if it works.