Hi
I have a stacked bar chart with 4 measures in each bar. Each bar represents a Name on the Rows shelf. This is created using measure values (on columns) and measure names (on color).
What i want to achieve is moving the row header (E1, E2 , E3 ,E4, E5) to the top of the each bar rather than to the left of it.
I tried to create a dummy Name field and drag it to the columns shelf (as recommended in another thread), but the view was duplicated many times.
I really appreciate your support in that.
Hi Ammar have a look at this.
To achieve the desired result I added 5 rows of data with value 0 - one for each name.
This could be done manually in excel or using sql if data comes from a data warehouse.
Check out the report and the excel file and let me know if you have any questions
