Quarter Field values be Q1 and Q2

[Kpim]

Hi

I know this code : dual('Qrt' & Ceil(Month(Date)/3), Ceil(Month(Date)/3)) for quarters   but I want to create a line graph showing  the dates that fall in Quarter 1 and 2.

How can I do that ?

[vinieme12 · Accepted solution]

use your Date field as dimension and restrict data for Q1 and Q2 using Set Analysis

example

dimension  = Datefield

measure = sum({<quarterfield={'Q1','Q2'}>}Sales)