Condition for Dimension

[upaliwije]

Hi.

I have apivot table in my QV Doc. There I have 3 Dimensions namely  Policy_no ,Name and Year.   Premium Amount as measure.

My Pivot Table is shown below

My Problem is here I want to show records which has a premium against year 2017. In other words records shown in 1,2 5 should be in the Pivot table and 3,4 should not appear. Pls help me to do this

[tresesco]

Could you share your sample qvw?

[upaliwije]

Here is my sample data

[tresesco · Accepted solution]

PFA

sum({<POLICY_NO={"=Index(Concat(Distinct YEAR,','), '2017')"}>}Premium)