Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Calculated table based on slicer selection

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!

1 Reply

  • Anonymous , A calculated table can not use a slicer of filter value.

    Create a visual table, that can use slicer value