I ahve a straight table as attached in the image. I want to transpose this. I want my months to be shown as Columns and Measures as rows. I tries pivot table as well but it wont take measures as dimensions. Can a nyone help em in this?
When we do the transformation we can add only total of dimension value ( u r case Month ) at the end column. if u wish to shown YTD measure as column then it's possible in previous transformation state. i would suggest you to provide mock data and expected output then we can try if there workaround method.