Skip to Content

How to create Dynamic Local Member for report

Feb 13 at 09:35 AM


avatar image
Former Member

Hi all,

I have some problem when I tried to create report which should be shown the data for 12 months and each month include 4 columns (first 3 columns is retrieved from system normally and last column is local member which calculated from column 2 and 3). Now I can do only fix local member of each month which it's not flexible when there is some change in report so I would like to ask all experts that how can I create dynamic local member for this case and is it possible, if there is no data for some months, the report should be suppress too but when the data is entered, it can be shown local member properly as other months

Thanks in advance for your answer.


report-design.png (35.6 kB)
local-member.png (52.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Feb 13 at 11:49 AM

Please provide details about your column axis: dimensions used and members selected!

I can see TIME, but the rest is not clear!

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Vadim,

Column Axis consist of:

1.) TIME

2.) AUDIT ID: 10REV, TXB000, DNA110

3.) ACCOUNT: L40, R01_899999, Donation_RP008