Smart Text / Summary Number

Rupak
Rupak Member
in Beast Mode

Hi Friends,

Requesting for your help on this, please.

Example
I have three columns, 'Student IDs' and 'Course Category' (Science, Math, History) and another column which is 'Location' which I have it in filter

Now I wanted to write in a text box. (Dynamic)
Location has more number of Course Category students.

Example : NY has more number of Science Students


Here Location and Course category should dynamically change when location filter is applied.

How do I achieve this? Please help

Thanks in Advance.


Tagged:

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    I don't know if you need an argument/condition in your rows but if you do it would be:

    CASE WHEN [argument] THEN CONCAT(`Location`, 'has more number of ',`Course Category`, ' students') END

    Otherwise it would be: 

    CONCAT(`Location`, 'has more number of ',`Course Category`, ' students')

    If I solved your problem, please select "yes" above

Answers

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    I don't know if you need an argument/condition in your rows but if you do it would be:

    CASE WHEN [argument] THEN CONCAT(`Location`, 'has more number of ',`Course Category`, ' students') END

    Otherwise it would be: 

    CONCAT(`Location`, 'has more number of ',`Course Category`, ' students')

    If I solved your problem, please select "yes" above

Categories