Straigh table with set analysis

[julruiz123]

Hi!

In the next two tables there's a relation with the field "Agrupador"

I need to create a straight table that shows for each year and month the "Facturación" value and "Data" value.

Ejm:

Agrupador     Año     Mes     Facturación          Data

ARP             2011    jul        $87.916.239,28     211,12

How i can do that with set analysis.

I need to do something like that:

=Sum({$<[Año Presupuesto]=Año, [Mes Presupuesto]=Mes>}Data)

Thanks!

[v_iyyappan · Accepted solution]

Hi,

     Using the following expression

     =Sum({<Año ={$(=Max(Año))},Mes={$(=Max(Mes))}>}Data)

hope its help you.

Regards,

Iyyappan

[julruiz123]

Thanks lyyappan V!

I used in this way, just i added a condition if there isn't a selection.

Regards!