HELLO EVERYONE, I WANT TO ASK FOR HELP ABOUT MY APP.
VIRTUAL COLMN
"SORT(FILTER("NEWDATA",
OR(ISBLANK([_THISROW].[CODE]), contains([KODEX],[_THISROW].[CODE])
)),FALSE)"
RESULT
I WANT TO COMBINE THE SAME NAMES, AND SUM THE FIELD KILO.. ?
PLEASE HELP ME
In your table view that is displaying the values there is an option for Grouping and another for Group aggregate. see image.
Choose your name column as the Grouping column. Then dropdown the list under Group aggregate to find the "Sum::Kilo" item to show the summed value for each grouping.
I hope this helps!
yeah that's very helpful, but i want to make it from virtual column. made with script. thanks
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
5 |