Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have 2 dimension columns in my pivot table which sort the order of my measure columns very nicely. However, the first dimension column doesn't need to be visible. Is there any way I can hide this column without losing the structure of my pivot table?
Ideally, I'd like the entire column hidden, rather than this greyed out column.
Thanks!
Hello @chriskan
If the only thing the first dimension does is ordering the second dimension,Ii would suggest to delete the first dimension from the table and order the second dimension by an expresion.
Then you create an expression with the rank function to sort it. Let me show you an example:
I have the following pivot table, with my desired order (The Category field with alphabetical order)
However, If I delete the first dimension, i got this order, which i dont want.
But if in the "Order by expression" in the Subcategory field, I use the rank funcion this way:
(I multiply the Category rank by 10000 because I want it to preveil in the order)
Then I get the order I had in the first screenshot, whitout the first dimension.
You can try and replicate something like this for your dimensions.
Attached is the example qvf.
Best regards.
Hello @chriskan
If the only thing the first dimension does is ordering the second dimension,Ii would suggest to delete the first dimension from the table and order the second dimension by an expresion.
Then you create an expression with the rank function to sort it. Let me show you an example:
I have the following pivot table, with my desired order (The Category field with alphabetical order)
However, If I delete the first dimension, i got this order, which i dont want.
But if in the "Order by expression" in the Subcategory field, I use the rank funcion this way:
(I multiply the Category rank by 10000 because I want it to preveil in the order)
Then I get the order I had in the first screenshot, whitout the first dimension.
You can try and replicate something like this for your dimensions.
Attached is the example qvf.
Best regards.
This worked perfectly, thank you!!