Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
No problem
You should be able to do that... let me see if I can make than work for you.
Hi
We are able to find it using your expression. Thanks
So it worked now?
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
Yes.. Perfectly
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
Regards
Senthil