Hello to everyone and thanks in advanced for taking the time to help me out.
My problem is basically a sorting issue and it consists of the following:
I'm using a pivot table and I've got 4 dimensions (Year, Month, Invoice and Customer) and one very simple expression ("Sum(Amount)").
I wish the sort order to be the following:
Year (ascending)
Month (ascending)
Invoice ( ascending by amount)
Customer (ascending by amount)
However when I set the sort order ascending by Year and Month, it stops sorting my customers and invoices by amount. I have to select a specific year or month for the sort order for customer and invoice to kick in. If anyone out there could help me would greatly appreciate it.
Also if there's any other information you might need, please just ask.
Cheers,
Josue
