Need logic help..

[lalitkgehlot89]

Hi,

In attached data I want to show employee growth over in line chart.

With full accumulation and with full data it is showing correct result.

But by default I want to show only data of Max year. in this case value is coming wrong.

Please help me out asap..

Getting Result.

Expected result on without any selection.

Regards,

Lalit Kumar

[Clever_Anjos]

Use Set Analysis

COUNT({<Year={"$(=Max(Year))"}>} your value)

[maxgro]

look at the attachement

[lalitkgehlot89]

Hi Maxgro,

Data which was given to you was with accumulation.

Please find the attached data without accumulation.

I want to show Employee growth over MonthYear and without any selection it should be show Max Year data.

Regards,

Lalit kumar

[er_mohit]

Hi

PFA.

Hope it helps.

[susovan]

Hi lalit,

Its might be work,

Sum({<Year={"$(=Max(Year))"}>}Your Value)

[yadhunandhanan]

Hi Lalit,

Use this Expression,

if(GetSelectedCount(Year)=0,Max({$<Year={"$(=Max(Year))"}>}WORKER),Max(WORKER))

Hope it helps.