Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, everyone.. I need your help..
I have a pivot table with this formula:
=rangesum(above(COUNT( {<FechaEquivAdmision={">=$(diaActual)"} >}DISTINCT IDSOLICITUD), 0, rowno()))
but i need the accumulate data since the begining FechaEquivAdmision and my table only show the accumulate since diaActual.
Help me please!
Regards
Catalina
So you only want your table to SHOW records since diaActual. But you want the ACCUMULATION to include all data since the very first FechaEquivAdmision, even though it isn't shown in your table?
Pardon my horrible mixture of Spanish and English...
Generate an AsOf table for your data that links every Fecha to itself and every previous Fecha. Here is some example data:
AsOfFecha, FechaEquivAdmision
Jan 10 2010, Jan 10 2010
Jan 10 2010, Jan 9 2010
Jan 10 2010, Jan 8 2010
...
Jan 10 2010, Nov 22 2007 <-- or whatever your very first FechaEquivAdmision is
Here's a simple way to generate it, though not the most efficient way (and untested):
AsOf:
LOAD DISTINCT FechaEquivAdmision
RESIDENT SomeTable
;
LEFT JOIN (AsOf)
LOAD FechaEquivAdmision as AsOfFecha
RESIDENT AsOf
;
INNER JOIN (AsOf)
LOAD *
WHERE FechaEquivAdmision <= AsOfFecha
;
Now instead of your current approach, set up your chart like this:
Dimension = AsOfFecha
Expression = count({<FechaEquivAdmision={">=$(diaActual)"} >} distinct IDSOLICITUD)
If I did all that right, the result SHOULD be a chart that only displays FechaEquivAdmision > diaActual, but accumulates the total count from the very first FechaEquivAdmision.