Issue with Pivot table

chamarthiprathy — Wed, 07 Jun 2017 09:45:29 GMT

Hi All,

Example: I have 4 Years data 2014,2015,2016,2017.. I want Display Only Current Year Month wise Sales renaming years want to display years wise .. If Fiscal year is Starts from July to June .. Now Current month is May now i want display June Month as Empty in Pivot as Current Month June See Reference date:

Current Month Year in Pivot:

2017

July Aug Sep Oct Nov DEC Jan Feb Mar Apr May Jun AVG

100 200 300 400 500 600 700 800 900 1000 1100 - 6600/12=550

Can you please help me asap guys..

Thanks,

Rajesh..

topic Issue with Pivot table in QlikView

Issue with Pivot table