Ive created a data set using Power Query. From that Data set I am creating a pivot. The pivot works fine except for one thing, the date field includes the greater than and less than symbols and I cant figure out how to get them to go away. Any suggestions? Something Ive noticed, is that the dates on which these symbols are connected are a year apart, essentially <8/13/2020 and >8/12/2021 the only significance of that date is that it seems to have been when I built the query.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
> and < Symbol in Pivot Table
- Thread starter Warpug
- Start date
Excel Facts
Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Similar threads
- Replies
- 4
- Views
- 915
- Replies
- 3
- Views
- 577
- Replies
- 0
- Views
- 313
- Replies
- 0
- Views
- 453
