Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Create a table from an existing table

I have my imported data from Excel called "Peru", in this table i have the list of employees that participate in a program.

Some of the the columns i have in this table contains the managers ID of each employee, the status and the points each have.

I need to create an automatic table from only the ones that are managers (i would only consider the ones that appear in the Manager ID column), and show the status they have and the points each one have.

I tried with this formula but didn't work:

Table = SUMMARIZE('PERU','PERU'[Manager Login ID],"Cant. Recn. por Manager",COUNT('PERU'[Points]))

 

How can i do it??

thanks a lot!!

Need Help

1 Reply

  • rocky09's avatar
    rocky09
    Solution Sage
    7 years ago

    try this

     

    SUMMARY = SUMMARIZE(CALCULATETABLE(Table1,Table1[DESIGNATION]="Manager"),Table1[NAME],Table1[DESIGNATION],"Sum of Points",SUM(Table1[POINT]))