Accumulated sum until a filtered date in pivot table

JuanGuti_Taligent — Fri, 10 Mar 2023 20:09:21 GMT

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?

Re: Accumulated sum until a filtered date in pivot table

rpennacchi — Mon, 13 Mar 2023 21:42:48 GMT

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)

topic Re: Accumulated sum until a filtered date in pivot table in App Development

Accumulated sum until a filtered date in pivot table

Re: Accumulated sum until a filtered date in pivot table