Show the value at Month End

[Dayna]

Hello All,

I have a list of data that shows the inventory for each date, but what I would like to do is show what the value is at the of the month..

I've tried using monthend(Date) from a load statement, but this gives me the amounts within that month.

Please find attached an example report based on what I'm trying to do, please help!

Many thanks,

Dayna

[jvitantonio]

Here you go

[Dayna]

Hello, I don't want the sum of the values for the month, but just the individual value that's on the date that's the end of the month. So the value on the example for the 29/02/2012 would be 54. Hope that makes sense! Many thanks, Dayna

[jvitantonio]

Oh, ok, I get it. You can do ir directly in a pivot table. No need to create a new table or duplicate data in memory. Anyway, if you need to create a new table, I wrote also the script and commented it out.

I hope this helps.