The way to do it is by setting a filter in your analysis not returning any data for 2014 AND (PQR or XYZ).
If your analysis doesn't have data for these columns the pivot will not show you these 2 columns for 2014.
So by adding a filter like:
"Year"NOT IN 2014 OR "Your columns" NOT IN ('PQR', 'XYZ')
There is data for both year 2015 and 2014.
Having data for 2014 and 2015 is normal or why to make an analysis if no data
But the point is that if you want your pivot to only display ABC for 2014 you must get in your analysis only data for ABC in 2014 !
That's why it's up to you to filter your analysis in a way to achieve this (and the filter example posted above does that).
I tried the filter as same as you have given.
But it's not working.
It's Showing data only for 2015 and it is hiding all the Data for 2014.
1 person found this helpful
Double check the logic of your filter. Have a look at the above example on SampleApp406 : both "Stockplus Inc." and "Tescare Ltd." have data for 2010, but because of the filter in 2010 only "Genmind Corp" is returned from the DB and so the pivot show that single column value for 2010.
Thank You So Much Gianni.
It is working fine.
I think I missed something earlier.
Thank You So much.