MonthYear and Month Selection Problem

[Rajkumar]

Hi all,

I have two fields YearMonth and Month .If I select Month previous year value is showing correctly and when I select YearMonth  the value is not showing for prev year value.

My expression :  =Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)

I wanted both  fields to  work correctly for expression 

.

Thank you

[kaushiknsolanki]

Try this.

Sum({<Year = {'$(=Max(Year)-1)'},YearMonth=>} Sales)

Regards,

Kaushik Solanki

[Rajkumar]

Thanks  for @kaushiknsolanki  quick reply.

If I use this expression, the YearMonth Selection is not working.

Sum({<Year = {'$(=Max(Year)-1)'},YearMonth=>} Sales)

[Kushal_Chawda]

try to exclude selection of YearMonth & Month

=sum({<YearMonth,Month,Year = {'$(=Max(Year)-1)'}>} Sales)

[kaushiknsolanki]

Hi,

Try this.

Sum({<Year = {'$(=Max(Year)-1)'},YearMonth=,Month=('$(=Maxstring(Month))')>} Sales)

Regards,

Kaushik Solanki

[Rajkumar]

Thank you  Solanki  for response.

It is applicable for only one selection. There are chances that users select more than one.