Get Row Values as Field Nams

[CrayonZac]

Hi Experts,

I have a fuzzy question about reframing table.

I was wondering is her any easier way to get the changes as following:

Customer	current date	operating income	liquidity	other income
1	16-Dec	1000	300	4
1	17-Dec	2000	400	5
1	16-Jun	3000	500	6
1	17-Jun	4000	600	7
1	18-Jun	5000	700	10
2	16-Dec	500	45	1
2	17-Dec	750	12	24
2	16-Jun	900	532	5
2	17-Jun	140	132	6
2	18-Jun	900	12	7

customer	16-Dec Operating Income	16-Dec Liquidity	16-Dec Other Income	17-Dec Operating Income	17-Dec Liquidity	17-Dec Other Income	16-Jun Operating Income	16-Jun Liquidity	16-Jun Other Income	17-Jun Operating Income	17-Jun Liquidity	17-Jun Other Income	18-Jun Operating Income	18-Jun Liquidity	18-Jun Other Income
1	1000	300	4	2000	400	5	3000	500	6	4000	600	7	5000	700	10
2	500	45	1	750	12	24	900	532	5	140	132	6	900	12	7

I want to calculate Last 12 Month Value, however, the data is not by days, but as Year To Day. I want to do the transformation because I think Multi Fields Formula could make it.

Is there any other recommendation on that?

Thanks a lot.

[JohnJPS · Accepted solution]

Hi @CrayonZac,

Sure, it's sort of a partial transpose, so I would approach it with transposing with key fields Customer and current date.  Then combine fields current date and "name" from the transpose.  Finally, cross tab back, grouping by customer, and your combined field from the last step as the header, and the value from the transpose as, still, the value. See attached workflow for exact solution.

[CharlieS · Accepted solution]

A little bit of transformation is needed to make this happen. Check out my attached solution and let me know if you have any questions.

[CrayonZac]

Hi there,

thanks a lot. May need more works on Dynamic Calculations.

[CrayonZac]

Thanks again. It helps a lot.