How to calculate totals for multiple column in new table?

[Anonymous]

Hello, I have several week columns (over 200) for sales by state. I would like to know if there is an easy way to calculate these totals by row in another table. (similar to a pivot function in Excel)

Current table:

State    W1 W2 W3 W4 . . .

TX         5    2     4     3

NM       1    3     5     4 

AZ        7     2     1     5

Desired Table

Week #  Total/Sum

W1           13

W2           7

W3           10

W4           12

.                 .

.                 .

.                 .

[Phil_Seamark · Accepted solution]

Hi @Anonymous

In the Query Editor,  Select go to the Transform tab.  Make sure you have the first column select and use the Unpivot other columns feature.

This should convert your data to the format below, which is ideal for building measures over.