Categories in rows by month on columns

[Luiscv73]

I have this data table:

Member	Date	Fund	Adjust	TotalExp
Member1	1/25/2022	50.1	12.45	-102.8
Member1	2/6/2022	52.4	10.8	-35.6
Member1	3/25/2022	80.5	15.4	-40.5
Member2	1/8/2022	52.4	10.8	-35.6
Member2	2/14/2022	65.9	22.8	-63.4
Member3	6/1/2022	96.5	25.4	-58.4
Member3	3/25/2022	84.6	15.7	-57.6

I have in a table visual the following output:

Row Labels	Member	Sum of TotalExp	Sum of Adjust	Sum of Fund
Jan	2	-138.4	23.25	102.5
Feb	2	-99	33.6	118.3
Mar	2	-98.1	31.1	165.1
Jun	1	-58.4	25.4	96.5
Grand Total	3	-393.9	113.35	482.4

However, I need the output in this way:

Values	Jan	Feb	Mar	Jun	Grand Total
Distinct Count of Member	2	2	2	1	3
Sum of TotalExp	-138.4	-99	-98.1	-58.4	-393.9
Sum of Adjust	23.25	33.6	31.1	25.4	113.35
Sum of Fund	102.5	118.3	165.1	96.5	482.4

I have try unsuccessfully with the matrix data, I tried unpivot columns, but not getting the desired result. Please, any help?

Thanks  

[DataInsights · Accepted solution]

@Luiscv73,

Add measures to the Values field well of a matrix:

In the Format pane, go to Values and enable "Switch values to rows":

Result:

[Luiscv73]

Wow @DataInsights , exactly what I need. Really I have about three months working with BI, but your solution seems so ease now and I didn't find the way, that's why there are superuser like you. Thank you so much for your help.

[DataInsights]

@Luiscv73,

Glad to hear that works. These forums are a great place to learn, and there's always something new to add to your toolkit. 🙂