Adding a new column containing text values

[WStansbury]

I have a field named 'Source'. There are several text names within the Source field (SoureA, SourceB, ...). How do I add a new column (field) containing the top 10 sources?

[Mikkel Jensen]

If you want to create at top 10 list showing most used sources you can do it by grouping on 'Source', counting the transactions, sort the counting descending, and set Top=10 (please see the screenshot).

However - if you want to analyze on several different sources i the same field you need to create a view that 'explode' these values to single transactions before creating the top list.

Mikkel

List options to be set when creating a top list based on a count.

TopList.png (31.7 KiB) Viewed 3807 times