Showing YTD values

[deepakqlikview_123]

Hi,

PFA.

I need to show YTD values for 2017 and 2016 , can you please suggest how shall i go ahead.

Thank

[kaushiknsolanki]

Hi,

Here is the solution.

Also Make sure you make below changes in script.

(Remove Field K from the Second table or You can use Concatenate Keyword Between two loads)

Regards,

Kaushik Solanki

[deepakqlikview_123]

Can you please suggest how shall i do this for max month

[kaushiknsolanki]

Hi,

It is already for the Max Month.

What exactly you are looking.

Regards,

Kaushik Solanki

[deepakqlikview_123]

Suppose if I want YTD for jun

[kaushiknsolanki]

Hi,

It is already for Jun.

Regards,

Kaushik Solanki

[deepakqlikview_123]

PFA.

In attachment In text boxes I am trying to calculate the vause for this year and last year for Maximum monthnum.

It seems is it not working properly.

Please suggest.