4 Replies Latest reply on Jun 19, 2018 6:31 AM by Zhouyi Zhang

    LOD (Level of detail)/ "Set analysis"/ Calculated static value for the sheet

    james cronje

      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