Calculate inventory when using date related dimensions.

[snoopyboy2599]

Hi all,

When I display the inventory, I want to use date related dimensions, such as year, quarter, month, dates, in the table.

If I use expression like Sum( { $< date = { '$(= Max (date) )' } > }  Inventory), it will only return the last row correctly and others will be 0s like below.

What I want to see is like this:

Month          Inventory

1                30

2                3000

I understand it's because $(= Max (date) ) = 22, but how do I alter it?

Any ideas?

Thanks in advance.

(above example in attachment)

[snoopyboy2599]

Anyone？

[snoopyboy2599 · Accepted solution]

Ok, solved it myself (poor me, no one answers).

The expression should be:

FirstSortedValue(Distinct Aggr(Sum(INVENTORY),DAY),-DAY)