Sort and Hide in a pivot

SSJKM06

Hello Team , Pls check below formate and Q's and let me know the solution ASAP

 

1) I want to order the data in a period column from Jan to Dec , it's calculated filed based on Date column from the data set. When I sort it's going by alphabatic order instead of 1, 2,

2 ) How to hide a row in pivot.

 

Sample Example : 

 

		Period	19-Aug	19-Jul	19-Jun			I want to order this data, it's calculated filed based on Date column from the data set. When I sort it's going by alphabatic order instead of 1, 2, 3
		Company	Amount	Amount	Amount	Amount Total		I want to hid this row in pivot
		ABC	1234	1242	356	55454
		DFD	12121	78754	231	454
		ERE	2434	453	3434	45454

 

Thanks

JK

ST_-Superman-_

Are you using the Pivot tables?  You should be able to use the actual date field as your Columns and then select "graph by" Month. 

 

 

I'm not sure about your second question.  I don't think there is a way to hide those labels.

SSJKM06

Thanks .Graph by Month will give me 2019-Jan but I want Jan-19 like that , I used calculation field to get values like Jan -19 as  string , when I sort it goes by A,B order.

 

2nd question is to hide the name of the column which is a measure which is called amount in my example.

 

Thanks

ST_-Superman-_

You should be able to sort by just placing the date field in the sort section. Even if you are using the beast mode calculation as the label.