table combination

[LeaRupnik]

Hello, 

I have some question, how to create a table like this. 

At first, a would like the year 2020 and 2019 then every month of the year 2019. 

Then about the level of a column, a would like to do mix table of table and matrix( with the fixed column).

Please help. 

thanx

LEa

[v-alq-msft]

Hi, @LeaRupnik 

I wonder if you want the following effect. I created data to reproduce your scenario.

Table:

You may go to 'Visualizations' ribbon, click 'Format' ribbon=>'Row headers', set 'Stepped layout' as off.

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[LeaRupnik]

thanks for this, i found these functions. Now I have a problem with sum year 2020 and the year 2019 and every month of the year 2020 in same column. 

Like this

year 2020	year 2019	jan.2019	feb.2019	mar.2019	apr.2019	may.2019	...

Thanks, 

Lea

[LeaRupnik]

hay, 

now i attach the file pbx, and I would like to get like this

ident	year 2020	year 2019	jan.2019	feb.2019	mar.2019	apr.2019	may.2019	...
1

https://drive.google.com/file/d/1d1cp2MfXO3QGDK1LZYGyiLSHGhbu0Fmg/view?usp=sharing 

Please Help. 

thanks

Lea

[Mariusz]

Hi @LeaRupnik 

The closest to your requirement would be Matrix Visual if this is not flexible enough then Paginated Reports is another option but it requires Premium capacity.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[LeaRupnik]

ok, 

how can i solve the year 2020 and 2019 and then every month of the year 2019? 

LP

LEa

[LeaRupnik]

Now i do like this, and now I would like to add a year with month 2019 .