Pivot Table Reference Question - Probably a very simple answer!

[sanantonio]

Hi All

I have a reference table on "Leaflet Zones" are sites are in. It's a one with an added measure to display all text separated by a comma. It looks like:

When I am then referencing that pivot table...

You can see the formula it brings up. When I try to change the "1001" to instead be a cell reference, L3 it just gives me #Ref. I've tried text(L3,0) and that doesn't work either. Only manually entering the code with the [] seems to work.

What am I missing to make that work?

Thanks in advance.

 

[shift-del]

Hi

I believe you have to add teh [] brackets in the formula.

...&"["&L3&"]"...

 

[sanantonio]

That got it thanks!