HI there,
I have a table that looks just like to what I included below.
I would like to get a Line chart that gives me a curve of costs for each month.
I cannot figure out how to add Date on the Dimension and sum value for the period as a measure.
| Apr-20 | May-20 | Jun-20 | Jul-20 | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 |
| £100 | £101 | £102 | £103 | £104 | £105 | £106 | £107 | £108 | £109 |
| £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 |
| £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 | £25 |
Could anyone help?
Thanks a million.
Jose
