1 of 1 people found this helpful
Please find answers to your problems.
Problem 3: Please find the attachment. I have joined both the tables. Just make it floating in the dashborad and join it. To make it floating you have to go to drill down and do it.
Problem 2: I have reduced the gap and left a tiny gap between the different department. T have used size marks to do that
Problem 4: Do standard and then manually drag the report to fit your choice. That will be more apt.
To remove Abc perform the following steps.
1. Go to Category and uncheck Show Header
2. Take Category and drop on Text/Label mark
3. Move Measure Name (last field under dimension) and drop it on top of the column where the header should be there
4. Type category using the keyboard
You will be left with two columns
Problem 1: I have not tried to do this. I will get back if I get to do any trick on that to change it,
However, find the link below which helps to change a header from top to bottom.
Hey thanks for your answer!
It helped me with problem 2 & 3 but it didn´t fix 1 & 2.
The link you´ve sent does it excactly the other way around from how I want it to work.
About problem two: The solution should look more like this
So the countries are grouped and in between different countries there is a bigger gap.
Thanks so far!