I have following table.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Segment[/TD]
[TD]Quarter[/TD]
[TD]No of stores[/TD]
[TD]No of sales[/TD]
[/TR]
[TR]
[TD]31/12/2017[/TD]
[TD]America[/TD]
[TD]Q1[/TD]
[TD]100[/TD]
[TD]45216[/TD]
[/TR]
[TR]
[TD]31/03/2017[/TD]
[TD]America[/TD]
[TD]Q2[/TD]
[TD]200[/TD]
[TD]6589[/TD]
[/TR]
[TR]
[TD]30/06/2017[/TD]
[TD]America[/TD]
[TD]Q3[/TD]
[TD]300[/TD]
[TD]2388[/TD]
[/TR]
[TR]
[TD]30/09/2017[/TD]
[TD]America[/TD]
[TD]Q4[/TD]
[TD]500[/TD]
[TD]6358[/TD]
[/TR]
</tbody>[/TABLE]
I want to display year end figures in the pivot table. I have created a measure for total sale. I want to display year end stores number too. How can I create a measure which displays Q4 number for the filtered year, and the segment.
Thanks in advance.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Segment[/TD]
[TD]Quarter[/TD]
[TD]No of stores[/TD]
[TD]No of sales[/TD]
[/TR]
[TR]
[TD]31/12/2017[/TD]
[TD]America[/TD]
[TD]Q1[/TD]
[TD]100[/TD]
[TD]45216[/TD]
[/TR]
[TR]
[TD]31/03/2017[/TD]
[TD]America[/TD]
[TD]Q2[/TD]
[TD]200[/TD]
[TD]6589[/TD]
[/TR]
[TR]
[TD]30/06/2017[/TD]
[TD]America[/TD]
[TD]Q3[/TD]
[TD]300[/TD]
[TD]2388[/TD]
[/TR]
[TR]
[TD]30/09/2017[/TD]
[TD]America[/TD]
[TD]Q4[/TD]
[TD]500[/TD]
[TD]6358[/TD]
[/TR]
</tbody>[/TABLE]
I want to display year end figures in the pivot table. I have created a measure for total sale. I want to display year end stores number too. How can I create a measure which displays Q4 number for the filtered year, and the segment.
Thanks in advance.