I agree with Chul. We've got a couple of different U8 members that read
Account Type for various situations which can be referenced. I assume
you're using getcell pulls, so for the greatest flexibility I'd probably
use a U8 that returns the account t...
Does he always want to exclude IT, or does it periodically change? it
it's a consistent request, you could potentially load IT to a different
U7 member. This could give you the ability to to toggle. Scratch this
suggestion if the request inconsistent...
Shetal,I had tried something similar a long time ago and got the same
results. It will involve a little more effort, but perhaps move your
macro in a separate file. You could then refresh the main .xlsx workbook
in OS, save it to your desktop, then h...
Hi Steve, If you don't mind running a macro, this one seems to do the
trick...A couple of things to note...This will only work with one cube
view per worksheetWhen cube views are added to a worksheet, a series of
range names are added. I've found som...