Pivot Query

[brandedadnan]

Hi All,

I need to find out a way to get this data without changing the pivot

Please see the instructions.

Thanks for any assistance.

[alansidman]

Put your customer and region in the filters area.

[brandedadnan]

Thanks for your quick response.

however I want region and customer to be in rows and month in columns

so that I can get a quick answer everytime.

So i cant place both in filter

[brandedadnan]

A dynamic formula to pick the following value from your Pivot table. (Should be dynamic so that if the customer or month or region is changed the result also changes)

[alansidman]

How about using slicers to filter.

https://www.pryor.com/blog/how-to-us...2010-and-2013/

[rorya]

I'm guessing this is an assignment of some sort, so all I'll say is GETPIVOTDATA.

[brandedadnan]

Hi Guys, Thanks for all your suggestions, @rorya. Yes I applied Getpivotdata and got it resolved.

Thanks