I am currently working on a report on BO XI 4.1.
Starting from a table with 3 columns, I want to end with a graph bars with only one variable:
- Name (dimension)--> Hided (it is ok, only have to select not visible as for axis value)
- Variable 1 (numbers) --> Hided (I can not manage to do it)
- Variable 2 (numbers) --> only bars to be displayed
I can not simply delete Variable 1 because a sort is made on these values... (Variable 2 are sorted according to Variable 1 figures)
I tried by clicking on the graph and then "assign data" but the option "hide" can not be ticked (see screenshot below)....
It seems that values can no be hidden....
If anyone has an idea on how to manage this I am interested.
I can send other screenshots if needed.