Problem in calculated dimension

[mishraamit2485]

Hi All,

I'm facing one issue in calculated dimension (Plz see the attached app)

I'm showing the Region and SubRegion both in the same chart depends on the selection.

Now if u select AMS its sub region countries(A,B,C) will come, now if you select A it will show only one row(1 Sub Region Country)

now if you select A again in the chart it should deselect the A and show all the sub regions (A,B,C) again which is not happening in the chart(Chart name is Problem chart in app)

But when i'm taking only subregion directly into the dimension(No Calculated dimension) it works well..click on A(u will see A) then click on A again you will (A,B,C)(Refer sample chart)

Please suggest how to do that:

[settu_periasamy · Accepted solution]

Hi,

Can you check this?

[Gysbert_Wassenaar]

A calculated dimension is an expression. If you click on an expression value then all the dimension values used to calculate that value are selected. If you click on that expression again it select the same values again. You cannot deselect these dimension values by clicking the expression value. You have to deselect the dimension values themselves.

[mishraamit2485]

Awesome Buddy...Great solution