Create a table from an existing table

[Anonymous]

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!!

[rocky09]

try this

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