calculate last 12 months average in pivot table

[Omkarsv2891]

final out put require last two column in qlik sense pivot table

[sunny_talwar]

@Omkarsv2891 would you be able to provide the sample data in an Excel file or qvf where the data is already loaded?

[Omkarsv2891]

i can share QVF file file size almost 80 mb  i ll try to reduce tomorrow and i will send