Hi,
I have a pivottable mit 2 dimensions (e.g. Month and Supplier) and a measure (e.g. Amount [per Month and Suppier]).
Now I want a pivottable, which sort the Suppliers within a Month by the Amount.
Jan
S3 10
S1 100
Feb
S2 100
S1 150
S3 200
...
or even better:
Jan Feb
1 S3 10 S2 100
2 S1 100 S1 150
3 S3 200
Is this possilbe?
Sinncerly,
Andre'