Need Help in pivot table

[tripatirao]

Hi,

I have a dimension =left(CalMonthName,3)&Right(CalMonthName,2)

that has value from Apr2017 to Mar2017

I have data till Jul2017

My Requirement is I want show data for Aug2017 to mar 2018 in  target .

for exemple

in july 2017 target is 439 I want to show this value from Aug 2017 to Mar 2018.

Regards

[tripatirao]

The value for the dimension is

Apr2017

May2017

June2017 upto Mar 2018

[el_aprendiz111]

Hi,

Would you be able to share a sample with the expected output?