WEBI Formula Question

[Former Member]

Hello,

I need to bring last month's Product's Ton values according to the Product as below. My problem is that values are being summed for all months, it is cummulated. But my aim is only bring the latest month values.

I have Month, Product dimensions and Product Ton measure.

My source data is BICS from BW.

I am using 4.1 SP4.

Data is coming like below firstly.

After I used formulas, result is seeming as cummulated by summing other months' values.

My Product Formula is   = ([Product] where ([Month] = (Last([Month]))))

My Moth  Formula is      = Last([Month])

I want to see like this.

Can you help me, please?

Best Regards,

Tarumar

[Former Member · Accepted solution]

[Former Member · Accepted solution]

Hi Sujitha,

Your formula and Rogerio's formula are working well.

Thank you very much.

Best Regards,

Tarumar

[Former Member]

hi, try Sum([your measure] where ([month]=(Last([month]) In Report)))

cheers,

ROgerio

[Former Member]

Hi Rogeria,

Thank you very much. Your formula and Sujitha's formula work.

My Best Regards,

Tarumar