Skip to Content
0
Former Member
Jun 03, 2013 at 04:26 PM

Cross tab - ordering chart x axis

26 Views

Hi,

I have two dimensions/formulas, for example, product and column order.

Product: Butter. Column Order: 1

Product: Apple. Column Order: 2

Product: Milk Column Order: 3

In a chart I need to display the product but order based on the column order dimension.

I am having problems doing this. I am using a cross tab and using this to build the chart. The x axis always is the top header row i.e. Product as I want this displayed as the x axis. The second row at the top is column order. If i set the column order as "Specified order" - it doesnt work as product is set to ascending.

The above is an example only of the requirement I have. Obviously in the example. could just order the product as specified ordering. But this wont work in the real life scenario i have.

Can I used formulas to do a specified ordering on the product i.e. i could say if column order is 1 then place product butter as 1 etc.

Cheers,