Merge data or columns in table

Comments

6 comments

  • Avatar
    Siva

    Hi,

     

    Anyone can share some ideas on how to create a plugin to achieve this requirement.

     

    Regards,
    Sai Krishna.

    0
    Comment actions Permalink
  • Avatar
    Sam Ovenshine

    Hi Sai,

    This would require custom scripting. Something like having two columns, one for absolute amount, another for percentage. Then grabbing the values from the second column and concatenating them into the cell value for the first column, and finally hiding the second column. This is something you would need to develop or use our Professional Services team to develop.

    Thanks,
    Sam

    0
    Comment actions Permalink
  • Avatar
    Siva

    Thanks Sam, Can you please share any similar PlugIn developed so that we can take that as a reference to develop our requirement. 

    0
    Comment actions Permalink
  • Avatar
    Brian Wilson

    Hi Sai,

    I was wondering if you had any success with this one?

    0
    Comment actions Permalink
  • Avatar
    Jim Thomas

    Sal/Brian,

    If the values are not dashboard calculations you can use a calculated column in your ElastiCube to create the string to display in your pivot or table.  Something like:  Opp$ + ' (' + Opp% + ')'   I assume since you mentioned Aggregated Table they are dashboard calculated values, so this won't help you.  But I thought I would mention.

     

    0
    Comment actions Permalink
  • Avatar
    Brian Wilson

    Hey Jim,

    Your fears proved true, these are dashboard-level calculations. Thanks for the idea though!

    0
    Comment actions Permalink

Please sign in to leave a comment.