Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

WEBI Formula Question

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

Tags:
Former Member
Former Member replied

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question