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 |
Solved! Go to Solution.
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.