rows

2 Topics

Report builder - how to create rows based on other rows
Hello everybody. I'm not sure if the name of this post is descriptive enough, but I'll try to describe my problem better here. I've been working with Report builder for 2 days, so please be kind if my question is stupid. I have a table where I have multiple columns with data(numbers) and one column based on which I'm summing those numbers. Something like this: Naming column Data_column_x Data_column_y Data_column_z Data_column_q US Germany Now, what I need is: for some countries I need rows which would be basically the same country name, but with some kind of % values. So it would be named something like "US[%]" and "Germany[%]" For those rows I need to calculate the values. Calculation might be something like this: (Data_column_x for US)/(Data_column_x for Germany) or (Data_column_x for India)/(Data_column_x for Germany). So there would be always Germany data involved in the calculations, cause it's percentage Germany data. There are 2 problems here: How to create those rows, which would be based on already existing row names, so basically duplicating certain row names with addition of some sort of "flag" (e.g. [%]). And another one is how to get data for one specific country so I can use it in my calculations for those rows. My amateur idea was to create new dataset with data only for that one country which I need in those calculations, but I was not able to combine 2 datasets in one table. Thank you very much in advance for all the tips!
Solved
Anonymous
4 years ago Place Report Server
2.9KViews
0likes
1Comment
Report table design with data points in both columns and rows (need help)
Good afternoon, all! I am absolutely new to the world of Power BI paginated report design, and am in need of some assistance with a table design that includes data points in both columns and rows.... I have an existing report design in our current reporting environment (see pic), that contains data in both colomns and rows. This design works just fine, and the 3 rows (Description, Immediate, Lessons) each show up between each Record item (see pic). My question is, how would I create something similar as a paginated report? I have the below design: But, when I run the report in the PBI Report Designer, I get the following output: Any help would be greatly appreciated. Thanks, Scott
SAS_BI
5 years ago Place Report Server
413Views
0likes
0Comments