Kindly find the attached sheet in which I need consumption details of the Year 2015 from the Pivot sheet and if I change the filter year it should not change.
Hi jocky6688, this is a rather strange question.
If you do not want the value to change, but still want to use the filter area, why do you expect a formula reading from the pivot that won't consider the filtering.
Either it does or it doesn't. Then why not use a sumif(s), on the raw data range.
