line chart issue

[#1]

Hi

i have one table like below

now i want to show next month (May) value  50 for reaming month

how to show output in line chart please help

Input for line chart

Month    amount

Jan        10

feb          20

mar        30

apr         40

may       50

jun         30

jul         45

aug       65

sep       75

oct        80

nov       90

dec      100

Output for line chart

Jan	10
feb	20
mar	30
apr	40
may	50
jun	50
jul	50
aug	50
sep	50
oct	50
nov	50
dec	50

[sunny_talwar]

May be this:

=If(Month > Month(AddMonths(Today(), 1)), Above([Exp Name]), Sum(amount))

Where [Exp Name] is the name of your expression

[johnw]

I try to avoid using above(), since it will not produce the same results if you make different selections. If you select only future months, for instance, you won't see any data. If you select April and July, you'll see 40 for July instead of 50.

I also like my months to be month/years, even if displayed as months. I like to be able to use date functions on them. I wouldn't do that for same month in multiple years comparisons, of course.

Anyway, something like this:

if(Month<monthstart(today(),1),sum(Amount),sum({<Month={'$(=month(monthstart(today(),1)))'}>} total Amount))

[sunny_talwar]

Good idea John. I guess I was not sure how this was going to be used, but I agree that using Above() can be an issue when we are making selections .