Hi everyone

I want to do a basic example that I know will assist with my bigger issue.

Let's say I have three columns:

[Country],

[Person],

[Sales $]

If I wanted to have one sheet, reflecting only one value, how would I script this in the expression? (I have only had to do this on Qlik before and LOD I'm seeing how it helps for pivot tables or my tooltips but not in this case?)

For example, what "calculated field" expression would I use for the static/fixed percentage of sales for 'John' [Person] in 'South Africa' [Country] over total sales for all people and all countries?

Many thanks,

James