WEBI Formula Question
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?