Forum Discussion
Solved
Calculated table based on 2 different tables.
Hello everyone, Newbie here! Any help would be very much appreciated! Table 1 (unique ID) Net amount based on uniques ID ID net 1 200 10 -300 8 -60 9 100 12 150 ...
There are ties in ranking,
Table3 =
SUMMARIZECOLUMNS(
Table2[Employee or team],
Table2,
"Sum", SUM( Table1[net] )
)
Thank so much CNENFRNL for your reply, I don't want to take advantage of your kindness. but if I want to build on your first reply
I want to create a slicer with 2 bottons (top 5 bottom 5) when I select top 5 the green part will be selected and when I select bottom 5 the red part will be selected.
by the way, the below table is the same as the one right above but ranked this time!
if you could help with this I will be very grateful. whenever you are free! thanks again!