Line chart expression

[#1]

Hi all,

i'm trying below expression in Line Chart. I,m calculating the Cloverunit = A06129, Lens#=1, measure=Ave Lens Diameter(mm), PLDate = last 2 months sum of LCL.

In pivot table having another few more expressions that displays data from all the dates(Not restricted to last two months).

=Sum({1<[Clover Unit]={'A06129'}, Lens#={'1'},measure={'Ave Lens Diameter (mm)'},PLDate={">$(=Date(AddMonths(Max(PLDate),-2),'MMM DD YYYY'))"}>} LCL)

Now i'm getting line in chart for LCL for last two months , but that value line should display for entire data. Please find the attached screen shot.

Thanks in advance

Regards,

Venkat.

[#2]

try to change table to straight and use Acumulation in expression

[#3]

Hi,

I'm sorry mistake instead of Line chart i typed pivot table.

Using the expression in line chart.

Thanks in advance.

Regards,

Venkat

[#4]

can you post a sample file?

[#5]

Hi,

Please find the atached app.

Thanks in advance.

[#6]

fist thing is

i see that LCL is similiar to value, so last two monts LCL sum should be about 60*value:)

so chart on your screenshot is wrong

am i right?

[#7]

I didn't get what you mean to say ?

Please explain some more briefly.

Thanks in advance

[#8]

sum(value)

and

sum(LCL)

are almost equal right?

[#9]

Value and LCL are not equal.

But their values will have slight difference i.e; most of the Value field is greater than LCL

What i'm trying to acheive is i'm calculating last 2 months sum(LCL) and that calculated result(i.e;sum(LCL)) should show for all months in line chart.

I hope you might understand now, please let me know if you don't got it. I'll will try to make clear in better way.

Thanks in advance.

[#10]

i mean ALMOST EQUAL

this means that sum(LCL) of last two months will be much higher

so the linechart probably look more like:

right?