5 Replies Latest reply: Sep 11, 2018 1:56 AM by Gysbert Wassenaar RSS

    Item and Series Item

    Wanyun Yang

      Here is part of my data model: Table1 has field Item and Sales , Table2 has field Item and SeriesItem, which represents items within the same series.

      model.PNG

      In the layout, I have a table chart with fields SeriesItem and Sales. Here's my question: if I select an Item, I want the table show Sales for SeriesItem.

       

      For example, Here's the data in my model:

      ex.PNG

      So, when selecting Necklace, I want to see in my table chart:

      222.PNG

      Now in the table chart, I'm using SeriesItem as dimension, Sum({<Item={"$(=SeriesItem)"}>}Sales) as measure. But measure is only valid when one SeriesItem is selected.

       

      How should I modify my function? Any advice helps! Thank you in advance!!