I have a pivot table in the name of Company name, Employees and some other as dimension, also i have salary, expense, etc., as the measures. Can i change the position of the dimesions or measures without changing it in properties. I.e., can i click and move the particular column from one to another place?
Need this info immediaetly as i want to deliver a report by today.
I know we can move the vertical column to row column and row column to vertical column. My requimnt is i have a vertical column by say column1, column2, column3, column4. I want to click and drop the column1 in between column3 and 4. Is this possible?
You can do that too, though note that if you have conditional shows on your expressions you sometimes have to unset the conditon, add the new dimension, and then reset the condition, else the new dimension appears to the right of the expressions and can't be shifted to the left of them.
That's trickier, as Straight tables allow sorting but not grouping, and Pivot tables allow sorting but not grouping.
Try adding a Expression Sort that has the same expression that you want to sort on.
If however the users need to change this sorting order you could set each expression formula up within a variable, and have another variable that the user change to switch between those expression formula variables. You could then set the switching variable as the sort condition. This would be a fair amount of effort for not so much gain I think though.