Hi
When I am "Cross Tab" to use vertical date in horizontal format then it converts date format "-" to "_"
Please check 2nd table, error highlighted in red color.
| From below | | |
| Date | Country | Count |
| 01-Jan-24 | US | 1 |
| 01-Jan-24 | Africa | 1 |
| 01-Jan-24 | UK | 1 |
| 01-Jan-24 | Canada | 1 |
| 01-Jan-24 | France | 1 |
| 02-Jan-24 | US | 1 |
| 02-Jan-24 | Africa | 1 |
| 02-Jan-24 | UK | 1 |
| 02-Jan-24 | Canada | 1 |
| 02-Jan-24 | France | 1 |
| 03-Jan-24 | US | 1 |
| 03-Jan-24 | Africa | 1 |
| 03-Jan-24 | UK | 1 |
| 03-Jan-24 | Canada | 1 |
| 03-Jan-24 | France | 1 |
| To below | | | | | | | | | |
| Country | 01_Jan_2024 | 02_Jan_2024 | 03_Jan_2024 | 04_Jan_2024 | 05_Jan_2024 | 06_Jan_2024 | 01_Feb_2024 | 02_Feb_2024 | 03_Feb_2024 |
| US | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Africa | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| UK | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Canada | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| France | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Can we convert "_" to "-" again
