Create Multiple Columns

[bertal34]

Hello,

I am trying to create multiple fields to cover each scenario of MTD (TY & LY) and YTD (TY&LY).  

Attached is an example with input data and what I would like to see as output.

thank you,

Jesse

[T_Willins]

Hi @bertal34,

One formula tool with multiple If formulas does this.

[bertal34]

Thank you for your reply.  This is exactly how I'm solving the problem now, however it is mundane and I have several additional columns than just Sales & Qty.  I was looking for a different solution that was not so formula intensive.  Any ideas?

[T_Willins · Accepted solution]

Hi @bertal34,

That makes more sense than just what your sample data had in it.  Try the attached workflow.  I added a few extra fields test formatting.  The top part of the workflow generates the template to get the fields in the right order.  The bottom part puts the data into the right fields.  Union the template to the data and Join back to the source data.  A much more complex workflow, but much more dynamic.

[AbhilashR]

@bertal34 - would the attached approach work for you?

[bertal34]

@T_Willins 

Thank you so much for taking the time/effort to help me.  This is a slick solution that fits no matter how many measures I have.  Awesome!!

[bertal34]

@AbhilashR Thank you for offering a solution that works as well!