Customize table

[cleemas]

Hello,

I have 1 table, the column names of table 1(EHP_IN, EHP_OUT, RHP_IN, RHP_OUT, SHT_IN, SHT_OUT) - contains numeric values.

I need to create something like this: 

Where:

TEST 1 = EHP_IN, EHP_OUT 

TEST 2 = RHP_IN, RHP_OUT

TEST 3 = SHT_IN, SHT_OUT

IN/OUT = is sum all rows in column

I tried:
- Manage Relationships
- Unpivot Columns

Can you help me pls?

[v-diye-msft]

Hi @cleemas 

You might consider creating pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. That will be easier for us to use the raw data and do further work. 

[cleemas]

Ok, I created pbix file that contain some sample data. 

https://www.dropbox.com/s/8uy14oxu50siu8u/CustomizeTable.pbix?dl=0 

[cleemas]

Someone please help me, I don't know what to do

[parry2k]

@cleemas can you share sample raw data?

[cleemas]