I have the sum of amount for each shop and month. And then I need to get the amount of first (min) month for each shop. In order to get this I use a function TOP( SUM( AMOUNT )). Everything is OK in the table. Look below:
Shop
Month
sum(Amount)
Top(sum(Amount))
A
1
50
50
A
2
20
50
A
3
40
50
A
4
60
50
B
1
500
500
B
2
960
500
B
3
580
500
B
4
430
500
C
1
260
260
C
2
120
260
C
3
60
260
C
4
80
260
The problem appears when I try to show this function in the line chart. I need to place Month on the X axis. And the chart should look like this (three straight horizontal lines):