SOLVED
Cross tab function
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
wenyg
8 - Asteroid
‎03-14-2023
10:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
Would someone be able to help on how to transform my data looks like from pic 1 to pic 2? data is attached and made up for privacy purposes but in pic 3, it should be percentage of total cost. Thanks!
pic 1
pic 2
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
6 REPLIES 6
Towers
11 - Bolide
‎03-14-2023
10:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎03-14-2023
10:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks,
How do I add the % after the number under the percentage of row view?
14 - Magnetar
‎03-14-2023
11:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@wenyg I don't want to take the credit, I'm adapting @Towers solution:
If you change that number I've pointed to above, it will show more decimal places i.e. 2.
We're using the Multi-Field tool here to change all the data types to string to include the % sign, as these will no longer be recognised as numbers.
‎03-14-2023
11:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks, it works now.
14 - Magnetar
‎03-14-2023
11:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Shifty
12 - Quasar
‎03-15-2023
01:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Nice solve, @Towers!
