Accumulated sum until a filtered date in pivot table

[JuanGuti_Taligent]

Hi! i have to calculate Accumulated inventory from a storage center, i have to consider 3 dimenssions SKU, HIBRIDO and LOTE to calculate day by day in a pivot table. i did:

if(
GetSelectedCount(FECHA)=0
,sum(CANTIDAD_FINAL)
, sum(total {1<FECHA={"<=$(=max(FECHA))"}>}CANTIDAD_FINAL))

if i dont select any day it runs (it calculates Accumulated inventory separating SKU, HIBRIDO and LOTE)  but when i change the date that i what to analyze it doesnt calculate Accumulated inventory for each dimenssion. What do i have to change? 

[rpennacchi · Accepted solution]

Hello, JuanGuti_Taglient,

I think you don't need use total and neighter the if condition. Try only this:

sum({1<FECHA= {"<=$(=MAX(FECHA))"}>}CANTIDAD_FINAL)