Calculated table based on slicer selection

[NGC1_2]

Hello, 

I have a situation where we need to create a calculated table based on the slicer selection. There's an example attached:

If I select AC2023 the table only should show the data associated with this selection, but instead it shows nothing.

The expected result is to have a filtered table only with the selected data:

it´s not working:

Is there another option where a calculated column or table can recognize the slicer selection? for example if I select AC23 divide all the values by the AC23 data, which is conversion rate by period, country, year?

Many thanks!

[amitchandak]

@NGC1_2 , A calculated table can not use a slicer of filter value.

Create a visual table, that can use slicer value