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)
State W1 W2 W3 W4 . . .
TX 5 2 4 3
NM 1 3 5 4
AZ 7 2 1 5
Week # Total/Sum
Go to Solution.
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.
Proud to be a Datanaut!
View solution in original post
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Find out where you can attend!