Sort and Hide in a pivot

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

Find more posts tagged with

Comments

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.