Expression

[Anonymous]

Hi

Consider we have these there tables:

date	Mainaccount	Dimension	balance
10/1/2017	100	1	33
10/2/2017	100	1	28
10/3/2017	100	1	32
10/4/2017	100	1	40
10/5/2017	100	1	30
10/6/2017	100	2	20
10/7/2017	100	2	31
10/8/2017	100	2	36
10/9/2017	100	2	30
11/1/2017	100	2	29
11/2/2017	100	1	25
11/3/2017	100	1	24
11/4/2017	100	1	40
11/5/2017	100	1	42
11/6/2017	100	1	44
11/7/2017	100	2	65
11/8/2017	100	2	24
11/9/2017	100	2	50
11/10/2017	100	2	29
11/11/2017	100	2	30

date	sale
10/30/2017	1000
11/30/2017	1300

date	month
10/1/2017	10
10/2/2017	10
10/3/2017	10
10/4/2017	10
10/5/2017	10
10/6/2017	10
10/7/2017	10
10/8/2017	10
10/9/2017	10
11/1/2017	11
11/2/2017	11
11/3/2017	11
11/4/2017	11
11/5/2017	11
11/6/2017	11
11/7/2017	11
11/8/2017	11
11/9/2017	11
11/10/2017	11
11/11/2017	11
10/30/2017	10
11/30/2017	11

I would like to trace the Dimension Balance by sales per month<,the result should be like these:

month	Mainaccount	Dimension	Dimension balance	Total balance per month	Total sale per month	Toal %	Dimension %
10	100	1	163	280	1000	28%	16%
10	100	2	117	280	1000	28%	12%
11	100	2	227	402	1300	31%	17%
11	100	1	175	402	1300	31%	13%

[Anonymous · Accepted solution]

I have found the answer

=sum (total <month>aggr( sum(balance),month))

and

=sum (total <month>aggr( sum(sale),month))