I have following table.
<tbody>
</tbody>
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.
Date | Segment | Quarter | No of stores | No of sales |
31/12/2017 | America | Q1 | 100 | 45216 |
31/03/2017 | America | Q2 | 200 | 6589 |
30/06/2017 | America | Q3 | 300 | 2388 |
30/09/2017 | America | Q4 | 500 | 6358 |
<tbody>
</tbody>
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.