Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hiya
I have two main columns of use in a table of Orders
CustomerID, and OrderID
I am using CustomerID as a dimension, for how long each customer order takes, but I have to use OrderID, as a dimension, because each bar will group each CustomerID totals.
I want to show CustomerID lables not OrderID lables on my dimension
I know this will show two or more instances on the dimension axis of CustomerID, but this is what I require
please help.
I've had a look at the options in piviots and straight tables. You cannot set the label dynamically so setting the label to CustomerId on the ordered dimension is out.
Aggregating the measure also doesn't cause the dimension to split out along the lines you need either.
There is no way to hide dimension although you can order the least import ones at the end of your table.
One way you might want is to use a master items drill down so it starts at Customer then clicking on it gives you the detail at order level but again doesn't satisfy your exact brief.
As you allude to its not an obvious request to have to satisfy.
I've had a look at the options in piviots and straight tables. You cannot set the label dynamically so setting the label to CustomerId on the ordered dimension is out.
Aggregating the measure also doesn't cause the dimension to split out along the lines you need either.
There is no way to hide dimension although you can order the least import ones at the end of your table.
One way you might want is to use a master items drill down so it starts at Customer then clicking on it gives you the detail at order level but again doesn't satisfy your exact brief.
As you allude to its not an obvious request to have to satisfy.
Hiya
thank you for your help, it has helped
Kind Regards