Get the values in Pivot chart Qliksense

[akshay61]

Hi,

I am fairly new to QlikSense. I have a pivot chart consisting of "Order ID" as Row, "Year" & "Quarter" As  Column, "Sales" as Measure.

                                              The requirement is to get the values for the quarter having no values or 0 values of the same year if any one quarter  is having value.

For Example : In the above screen shot For Order ID = 100463807, Year= 2012 Q1 is having value 77700.24, I want to have same value for  the remaining Quarters of the same year For same Order ID.

Thanks,

Akshay