Make calculations based on multiple columns

[jsamstad]

Hello!

I currently have a table with a categorical variable in the first column and then a series of periods to the right. I'd like to perform calculations based on Type for each Period (eg. If Type = A and Period = 9, then give me this calculation: ( 1 / SUM( 2 + 3 ) ) or If Type = C and Period = 10, then give me this calculation: ( 4 / SUM( 2 + 3 + 4 ) ). I attached an example to help clarify. Thanks in advance!

TYPE	PERIOD 9	PERIOD 10
A	1	2
B	2	3
C	3	4

[ShankerV]

Hi @jsamstad 

Is this your dataset sample trying to test or you need to apply this for huge dataset.

[ShankerV]

@jsamstad 

If you need to apply for huge dataset, please explain the logic in detail.

We can achieve for the same.

[jsamstad · Accepted solution]

It starts out larger but is summarized into categories and then using the cross tab tool to unpivot the periods so the ending table is 8 x 13.