how to show the latest month information by using dimension
I am Having a table which consists of Months and targets now In the Pivot table I need to show the latest month target by ignoring the other months.
for example we are having 3 months data of one reporter and he is having 2 types of targets in 3 months(Jan, Feb, Mar) and now only the latest month target need to be picked and ignore the Jan and feb target and show Mar target it in chart dimension
