Dynamic pivot column by variable

[187]

Hi I seek some help from here

I got data like this

client	AUG	SEP	OCT
AAA	2A	3A	4A
CCC	2C	3C	4C

I have variable of month which could be set to AUG/SEP/OCT

i wanna get the value for client CCC on OCT which is 4C  if i pass the variable OCT and if i pass the SEP i want to have 3C return, what is the solution?

[atcodedog05 · Accepted solution]

Hi @187 

You can convert columns to rows and apply the required filter like below.

Hope this helps : )

[binay2448]

Please find attached solution for the same..