on 01-12-2017 11:52 AM
Dear All,
I m working on a dynamic report for my client and I m blocked about one specification that it asked :
Accordind to the value of a localmember (local member in column), if the cell is empty, the dimension member need to be suppress of the Row Axis. So I have to use VBA for that.
I already identify my loop and my condition. But I don"t how I explain to the system how suppress the member from the row axis.
For example :
Count = 10
For Each Cell In Sheets("Sample").Range("A10:A25")
If Cell.Value = Null Then
??????
Else
Count = Count + 1
End If
Is anybody have an idea ??
Thanks in advance
Kind Regards
Jonas
Thanks for your reply.
Yes, Macro seems to be right.
Unfortunately, I can't only hide. I have a Sum(EPMAllMembers) too.
What about the BPC RemoveMemberFromRowAxis action ?
I'm not sure it works ( or I don't know how it works.)
Furthermore, If you have an idea for filter on only one dimension member of three dimension row axis. It could be also good for me.
To be more clear I try to have a filter only on columns with Real figures. ( not budget or forecast).
Many thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, but in order to get some answer you have to prepare very clear explanation with very detailed samples and screenshots!
RemoveMemberFromRowAxis works fine if you have this member directly (not as a children of some parent)!
"If you have an idea for filter on only one dimension member" - absolutely not clear!
"To be more clear I try to have a filter only on columns with Real figures" - also not clear!
You can hide the row using VBA - no other options.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.