???
I can't believe how hard it is to sort data. I must be missing something very fundamental.
I have
Current month
Orders Project A $$
Project B $$
Sales Project A $$
Project B $$
I need to sort orders so the largest project is shown first. Then sort sales so that largest project is shown first. I've added a rank - which ranks BOTH orders and sales. How do I sort the rank column? I'm guessing I can't sort on orders and sales at the same time.
I think I'll clarify my post.
I'm reading a help manual and it says I need to click the current month column header and then click "sort". The dialogue box appears and then I'm to select BY VALUE under the ROWS section.
BY VALUE is not an option - it is greyed out. Why is that?