Indirect set analysis problem

[#1]

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!

[giakoum · Accepted solution]

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

Try this :

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

[#3]

Thanks!