How to make line chart able to display trend line appear when i click on month = 7 ?

[paulyeo11]

Hi All

I have a trend line , I like to make it able to display the trend line , when i click on month = 7.

Paul

[paulyeo11]

Hi Robert

Thank you for sharing with me John explaination on SET analysis which is 3 year back.

Paul

[sfatoux72]

You're right, I worked on the reason why the calculation was not calculated for every month. I used internal expressions without modification thinking they were correct.

Here the expression with the internal correction of Kush and my reorganization:

If(sum({<month=>}STK_CLOSE) > 0 and sum({<month=>}STK_OPEN) > 0,

If(Mod(RowNo(),12) = 0, 12, Mod(RowNo(),12)) * 30

*

RangeAvg(Sum({<month=>}TOTAL <year> If([YearMonth] = YearStart([YearMonth]), STK_OPEN)), sum({<month>}STK_CLOSE))

/

RangeSum(Above(Sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} (COGS+COGS_INT_)/1), 0, RowNo()))

)

[Kushal_Chawda]

Thanks Paul.

I am from India

[paulyeo11]

Hi Kush

Are you work in India also ?

Paul

Sent from my iPhone

[Kushal_Chawda]

Yes, I work here in India.