MS Excel / VBA help thread

You are reading a single comment by @Aroogah and its replies. Click here to read the full conversation.

•

Chalfie

Hi.
I'm struggling today. (hahahahahah)

I have 3 pivots. Controlled by one slicer.
One of the pivots tells me how many different languages are spoken at one organisation.

What I'd like to do is actually return the number of different languages in that org in a different cell. the data is held in a table on a separate sheet in the same book.

So:
Click org code slicer and select new org code.
this changes three pivots and their charts on the page.

I then want in cell b6 (for example) it to return the number of different languages spoken in that org code. make sense?
I thought it would be simple.

Alternatively, if b6 could say:

countif: orgcode,b1, languagespoke,NOTBLANK

or

if b6 could look at the number of lines returned in the pivot table controlled by the slicer and tell me how many there are that are not "unknown".

thanks.

•

Aroogah in reply to @Chalfie

You can reference blocks in a pivot table when creating single cell formulas, but it gets a bit nasty and unpredictable at times. I've had both spectacular success and frustrating failures.

Try it, it might work for you. Alternatively, can you add it as a calculated field in the pivot table itself?

About

Avatar for Aroogah @Aroogah started