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.


      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:


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


      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!!