Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a pivot table
Year against cars giving calculated value number of sales.
Now i can sort year and the cars but not the calculate value number of sales
is this possible and how can i sort?
e.g
2014 2013
fiat 200 150
opel 300 125
Mazda 500 100
Now i want to sort
2014 2013
Mazda 500 100
opel 300 125
fiat 200 150
Would this work ?
thx for your quick answer.
But i mean, sort the column number, also not model and not year but number sales.
Hope you understand what i mean.
You mean sorting the models from top to bottom depending on the sales numbers in either the first or second column (and not the row total) ?
yes
Here is my attempt...
Super. But it will not work with me.
Hi,
please have a look at this
How to use Button to show a data as an ascending order??
Regards
André Gomes
You can't sort one dimension in two ways. So sorting by expression won't work afaik. You can use a straight table or add a calculated dimension to the pivot table and sort by that calculated dimension. You could also sort the Store dimension by Y-value, but that will not only sort the category dimension, but the Store dimension as well.
Can you elaborate ?