on 10-19-2015 11:13 AM
Hello Everyone,
I have a problem which i think i should not have but the situation is this;
I define the interception of rows and columns as a name in excel below where column is dynamic;
So i expect that if there is a new bank, it will be dynamically in my name but the result i get is below;
Isnt it silly?
Thanks,
Emre
But i also need to sent the data to the system.
Emre
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok, at that area i would like to do a percentage calculation. The problem appears when we add a new bank because the formula doesnt automatically copied. So, i decided to create a range at that area and with macro i wanted to copy that macro to that range. Do you understand?
Emre
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, but absolutely not clear!
Can you talk in the terms of dimensions, members, row/column axis of the report, etc...
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Vadim,
Thanks for your reply.
In my row axis, i have subsidiary dimension and in column axis i have bank dimension. Row axis is static but colum axis is dynamic, so when they add a new bank it will appear at the report. But the problem is appears when they add a bank to the beginning or ending which is caused by alphabetical conditions Lets say in the beginning i have "b" and "d" banks in the system. There is no problem when i add "c" bank which will appear in the middle; my range which i called as "name" in the previous message is dynamically expanded. But when i add "a" bank or "e" bank, my range is not dynamically expanded.
Is that enough?
Thanks,
Emre
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.