Count expression to compare quarter by quarter

[jim_chan]

Based on this script,

I am able to get new item id of current year compare to last year.

=Count(DISTINCT {<item_id = e({<item_id = {"=Count({1<batch_year = {'<$(=Max(batch_year))'}>} item_id) > 0"}>})>} item_id)

What to change if i want compare it instead of by year , compare it by quarterly. ?

1st , I select year 2016, then I select 2nd half,

When I click on the 2nd half, it will compare with 1st quarter.it will compare any new item ID in the 2nd half compare to 1st half.

I have the field called - batch_type : with data 1ST HALF , 2ND HALF. can max(batch_type) , but is not a number.

Rgds

Jim

[vinieme12]

Can you post some screenshots of what you want to achieve?? and sample data??

[rubenmarin]

If the only values are '1ST HALF' and '2ND HALF' you can use MaxString() to get the last value sorted alphabetically.