Analysis Help

[tgumbing]

Hi,

In my example I nedd Help

I want to calculate "SalesClosed in Sales Month"

Thanks for your help

Thanks

[shraddha_g]

What is your data?

What you are expecting as a output.

Can you please elaborate

[prma7799]

Missing comma in your second expression

=sum({<SalesYear=,SalesMonth=,SalesClosedYear={$(=max(SalesYear))}, SalesClosedMonth=,SalesMonth>} SalesClosed)

If this is not fulfill your requirement then please share expected output.

[stabben23]

Hi Thomas,

Is this gives you correct output?

=sum({<SalesYear=,SalesMonth=,SalesClosedYear={$(=max(SalesYear))}>} SalesClosed)

[tgumbing]

I want this :

The column "SalesClosed in Sales Month" calculate the number of sales who

SalesClosedYear=SalesYear and fror each SalesMonth=SalesClosedMonth

I want to bring the number of clodedSales in the month Sales.

[tgumbing]

I want this :

The column "SalesClosed in Sales Month" calculate the number of sales who

SalesClosedYear=SalesYear and fror each SalesMonth=SalesClosedMonth

I want to bring the number of clodedSales in the month Sales.

[Anonymous]

Hi,

maybe something like this :

sum({<SalesYear={$(=max(SalesYear))}>} if(SalesMonth=SalesClosedMonth,SalesCounter,0))