How to get a Max Month row value into variable in WEBi

[former_member1186497]

Hi Experts,

I have a requirement in webi to identify the measure value from the row of Max month among all the existing month rows.

Below is the raw data with calyearmonth_MSEG in horizontal table.

Max calmonth is derived as below:

=Max([CalYearMonth_MSEG] ForEach([Material];[Plant];[Valuation Type];[SpecialStock])) In([Material];[Plant];[Valuation Type];[SpecialStock])

Max_month_MAP_Value is derived as below:

=[MAP] Where ([Max Calmonth]=[CalYearMonth_MSEG])

When we remove the Calyearmonth_MSEG from the default view, it shows the data with error as below.

But i need to show the data as below:

Can you please help me to correct the above formulae to show the expected values.

Thanks in Advance. Your help is really appreciated.

Muralidhar Reddy.

[former_member1186497]

raw-data.pngerror-in-data-after-removing-calyearmonth-mseg.pngexpected-data.png

Some how i was not able to paste the screenshots in above question but please find them as attached here.