Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
not sure why you only see one customer. A sample app would help.
Try this :
SUM({$<OrderDuePeriod={"$(=only(Period))"}>} [Family Balance])
not sure why you only see one customer. A sample app would help.
Try this :
SUM({$<OrderDuePeriod={"$(=only(Period))"}>} [Family Balance])
Thanks!