aggregation

[#1]

hi

     I need to show a list with years and values but only the years with diferents values. I can do it with a SQL but it's not the idea.  The example is

año   ,instalacion,potencia

2009 , 500,         ,1000

2010 , 500,         ,1000

2011 , 500          ,1000

2012 , 500          ,3000

2009 , 100          ,1000

2010 , 100          ,1000

2011 , 100          ,2000

2012 , 100          ,3000

the result will be:

2009 , 500,         ,1000

2012 , 500          ,3000

2009 , 100          ,1000

2011 , 100          ,2000

2012 , 100          ,3000

Not the records with de same potencia, and min(año)

[MayilVahanan]

Hi

     Try like this,

Load * Inline

[

año,instalacion,potencia

2009,500,1000

2010,500,1000

2011,500,1000

2012,500,3000

2009,100,1000

2010,100,1000

2011,100,2000

2012,100,3000

] Where potencia <> Previous(potencia);

Hope it helps

[#3]

Thanks, It's works but I need do the same in a table with the condition numinst=previous(numinst)

I try using sum with set analisys.