Calculate expression for minimum dimension. (pivot table)

asgardd2 — Wed, 05 Oct 2016 08:52:43 GMT

Hello!

I have some misunderstanding about how to create the correct expression.

My data model like this:

... ... ...

I have pivot table in my dashborad:

I want add new expression in the chart, which calculate Forecast for first date and for each product.

I created a formula, and it calculates the correct, but I think it can be done easier. Could you help me with this?

Aggr(Nodistinct

AGGR(IF(Date_ForeCast = Min(TOTAL <ID> Date_ForeCast),sum(Forecast)),Date_ForeCast,ID)

,ID)

I tried make exprressions ! without If statement, but they are not calculated correctly :

expression2:

AGGR(Nodistinct sum({<Date_ForeCast = {"$(=Min(TOTAL <ID> Date_ForeCast))"}>} Forecast),ID)

expression3:

AGGR(Nodistinct sum({<Date_ForeCast = {"$(=Aggr(NODISTINCT Min(Date_ForeCast),ID))"}>} Forecast),ID)

Application in attachment.

Thank You!

Best regards,

Aleksandrov Anton.

Re: Calculate expression for minimum dimension. (pivot table)

sunny_talwar — Wed, 05 Oct 2016 09:08:34 GMT

This is another option and probably better than using double aggregate:

Sum(TOTAL <ID> AGGR(IF(Date_ForeCast = Min(TOTAL <ID> Date_ForeCast), Sum(Forecast)),Date_ForeCast,ID))

asgardd2 — Wed, 05 Oct 2016 13:17:07 GMT

Thank you for your reply!

sunny_talwar — Wed, 05 Oct 2016 13:18:35 GMT

No problem at all