i want to calculate sum of rows and sum of colums of my table (sumA / sumB / sumC)
when i insert a virtual column “sum” for column “count” i use following expression (IF([product]=“sum”,SUM(SELECT(table1[count],[product]<>“sum”)),[count])) >>>
a new colum is insertet in the UX with “count-value” of each row and aditionally one “sum-value” - this is all done in a separate colum
how can i achieve this? many thanks in advance !
User | Count |
---|---|
17 | |
11 | |
7 | |
5 | |
5 |