Indirect set analysis problem

Tue, 01 Apr 2014 15:16:53 GMT

Hi,

I went over the various indirect set analysis links, but still to fail to achieve the following:

I have 2 tables with the same attribute (“Period type”) but with different field name for it.

The common field is Family.

Once the user selected a period type (from one table) and a family,

the data from the other table should be linked for the same period type.

In a pivot table I need to display:

- Customer

- Order number,

- Sum of the family balance

The following expression displays only one customer with one order.

SUM({$<OrderDuePeriod=p(Period)>} [Family Balance])

How do I get to see them all?

Thanks in advance!

Re: Indirect set analysis problem

giakoum — Tue, 01 Apr 2014 15:19:57 GMT

not sure why you only see one customer. A sample app would help.

Try this :

SUM({$<OrderDuePeriod={"$(=only(Period))"}>} [Family Balance])

Tue, 01 Apr 2014 15:28:45 GMT

Thanks!