Extension function

[louise119]

I would like to use an extension to display the table only when a required item is selected.
I'm using an if statement for the filter item.
How should I put the expression in the extended function?

I tried the below, but. I got an error(extension formula).

・filter formula：If(region='Japan' or region='US', Item )
・extension formula：GetSelectedCount("If(region='Japan' or region='US', Item )")>0

[Lisa_P · Accepted solution]

If you are using conditional function in the Add on section of properties, formula to hide/show should be:

Count({<region={Japan, US}>}Item)>0

[louise119]

Thank you so much!

And how should I transfer the data from sheet to sheet?
I use "Count({<region={Japan, US}>}Item)>0" on filter , I can't transfer the data I selected to other sheet.

[Lisa_P]

Normally selections should apply to all sheets. When you create a calculated dimension, it depends on the logic you are using.

 for your filter (calculated dimension) try this formula:

Aggr(Only({<region={Japan, US}>} Item), Item)