MTD

[#1]

Hi

ALT_DATE	MAR	AACTION
2015-06-02T00:04:25.76Z	150401SCBLAEADBDIF0724514887	OK
2015-06-02T00:18:29.69Z	150401SCBLAEADBXXX0724515370	HOLD
2015-06-01T00:20:34.60Z	150401SCBLAEADBXXX0724515376	OK
2015-06-01T00:20:34.60Z	150401SCBLAEADBXXX0724515379	OK
2015-05-01T00:57:31.61Z	150401SCBLAEADBXXX0724515584	CANCEL
2015-05-01T01:03:21.03Z	150401SCBLAEADBXXX0724515592	OK
2015-05-02T01:03:21.03Z	150401SCBLAEADBXXX0724515593	OK
2015-05-03T01:03:21.03Z	150401SCBLAEADBXXX0724515599	SVET
2015-05-04T01:03:21.03Z	20150401N008818979-1	OK
2015-05-03T01:03:21.03Z	150401SCBLAEADBXXX0724515600	OK
2015-04-06T01:19:21.15Z	150401SCBLAEADBXXX0724515602	ERRIDE
2015-04-01T01:23:20.98Z	150401SCBLAEADBXXX0724515606	OK

In the above sample data , We  need to find the MTD count of DISTINCT MAR with AACTION = OK , CANCEL, HOLD  for last 2 Months

[#2]

Hi

Thanks Mate. It was very helpful

Is it possible to Divide the last month MTD Volume / Previous month MTD Volume

In the example We need to divide June2 days volume by May 2days volume for each country

[sunny_talwar]

No problem

You should be able to do that... let me see if I can make than work for you.

[#4]

Hi

We are able to find it using your expression. Thanks

[sunny_talwar]

So it worked now?

[#6]

Hi

In the above example , if i want to show the countries only with morethan 100 % increase compare to last month.

How do i display that countries alone

Thanks

[#7]

Yes.. Perfectly

[#8]

Hi

Below is my Table Viewer Snapshot.

When i link ALT1 in AMSR_Apr and ALT_DATE in sheet 1 i get a circular Reference.

How do i avoid that

Circular Reference

Regards

Senthil