Accumulation Chart

[#1]

I am attempting to do an accumulation chart of our Freight Costs YTD and LYTD.   The LYTD is working great... but with the YTD I only want to see the chart up to the Previous Month.

Currently - it is adding "0" freight costs so my chart flat lines.  This is causing my trend line to be inaccurate based on YTD trends.

[sunny_talwar]

I am assuming you are using two expressions. For the expression which is adding bars for future month, you can do something like this:

If(Sum(Value) <> 0, thenAccumulateExpression)

[#3]

I have added that to my my formula.  But still getting the same results.

This is the formula I am using - Sum({<Year= {'2015'}>}FreightCost)

And then I select full accumulation at the bottom.

I think my formula needs to do the accumulation instead of the hot key in the chart properties.  But I don't know how to write it.

[sunny_talwar · Accepted solution]

Try this without full accumulation:

=If(Sum({<Year= {'2015'}>}FreightCost) <> 0, RangeSum(Above(Sum({<Year= {'2015'}>}FreightCost), 0, RowNo(TOTAL))))

[#5]

YOU ARE MY HERO!

[sunny_talwar]

Hahahaha, I am glad it worked

Sunny