Skip to Content
avatar image
Former Member

How to create Dynamic Local Member for report

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 13, 2018 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!

    Add comment
    10|10000 characters needed 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