Skip to Content
Aug 01, 2019 at 06:55 PM

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

100 Views Last edit Aug 02, 2019 at 06:14 AM 4 rev

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.