Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have data like this and I need to show a line chart with x-axis as jan,feb,mar and y-axis as it's total.
Jan | feb | march | april |
10 | 20 | 30 | 40 |
100 | 200 | 300 | 400 |
10000 | 20000 | 300000 | 40000 |
This should be straightforward, but usually the table would be formatted where one column was "month" and another column was "sales", and it would look more like:
Jan 10
Jan 20
Jan 10000
Feb 20
etc. Then you would just have "month" as the Dimension and "=sum(sales)" as the Measure to get what you want.
What you want to do is use the FIELD NAME as the Dimension and sum the values of the field with the matching field name... Which may be possible but it is convoluted.