Make calculations based on multiple columns

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

Transformation

Expression

Data Investigation

Accepted answers

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.

All comments

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

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

We can achieve for the same.

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.

Quick Links

Tags

This months top contributors

Hollingsworth 335