Forum Discussion
Line chart cumm(hELP)
Hello,
I have line chart in table 1 columns are period it has oth month..10th month, oth quarter..10th quarter values, i have sort column for period 0...9 values. i have cummulative take rate column it has cummulation values for every period i got in matrix table correctly but in line chart i am unable to get upto 9th month it came but 10th month it dropped can you help in this. i have period 1
Hi chaitanya1 ,
How are you doing the cumulative is it based on the period with the text values in this case 1st month, 2nd month?
If it is you are getting the 10th month right after the 1st month because it's alphabetical. You need to do the cumulative based on consecutive values, if you have sorting column use that column for the cumulative should work properly.
1 Reply
Hi chaitanya1 ,
How are you doing the cumulative is it based on the period with the text values in this case 1st month, 2nd month?
If it is you are getting the 10th month right after the 1st month because it's alphabetical. You need to do the cumulative based on consecutive values, if you have sorting column use that column for the cumulative should work properly.