repeat value until it changes

[ali_hijazi]

Hello

got a pivot table with dimensions Month-Year and Product

and the expression is FirstsortedValue(Price,-Period_Date)

so far the results are fine and when I select one product i get the following :

However when I select more than one product I get null values in months when there are no purchases for the product as follows:

is there a way to fill for example above for the first product May 2011 with 19 and May 2012 with 16.8282 etc....

Knowing that if I select a third product that might be purchases in April 2011 then I want to fill April 2011 with 19 for product 1 (the first one on the list)

Please advise

[Anil_Babu_Samineni]

Can you please post one sample Application with Raw data of sample and Expecting O/P as Picture

Then we can understand???

[ali_hijazi]

The data is something as follows:

Date       Product        Value

15/2/2016  P1              15.69

25/2/2016  P1              16.5

16/3/2016  P1               17.23

5/7/2016    P1               16.75

....

for the above product I want to display the following:

for Feb   16.5

for Mar    17.23

for Apr,May, June 17.23

and Jul 16.75 and so on...