How to show details about selected measure value in table?

[ElifGuler]

Hello,

I want to display details about just selected measure in a different sheet or another table in same sheet that doesn't matter. I attached my table. Second and third column show the number of tasks done in different months. I want to show just related customer of project names to the number. Do you have any idea or advice for me? Different solution is also ok for me. I can not make pivot table because there are too many customer names for different months and they all displays when I click on the responsible that is the first dimension.

[Aditya_Chitale]

If you are selecting measure from any dropdown or on button toggle, then you can prepare multiple charts each with different measures and add conditional show/hide on each chart (available under Data Handling -> Calculation Condition)

Regards,

Aditya

[ElifGuler]

I don't understand. Firstly, I select from table. Also, should I create a chart for each cell which means 5 months and 20 sales person which equals to 100 tables?

[MayilVahanan]

HI

Create the separate table with Project Names info and display only the user select single value in "customer" field.

or you can display the "Project Name" column in the same table with conditional [display only the user select a value in "customer" field]

[Aditya_Chitale]

you just need to create tables on month level if you are selecting measure as month. by default you will get all sales persons present in that month.

Regards,

Aditya

[ElifGuler]

I guess my request is impossible because let's say I want to see visits of Alex as sales person to 4 customers in this month, which means I want to see only these 4 customers' name at the table. If you say I have to choose month dimension and sales person dimension, then it is not necessary to create another table, I can do this at the same pivot table, cant I? 🙂

[Aditya_Chitale]

if you want table to show chart only on sales person and month selection, then you can do that also in single table. just add below expression in conditional show/hide in your chart. This way your chart will be displayed only on selecting atleast 1 sales person & month.

=if(getselectedcount(salesperson)>0 and getselectedcount(month)>0,1,0)

Regards,

Aditya