Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem with creating a chart.
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):
Any ideas how to manage that?
Here is the application...