Expressions Clickable on Pivot Chart

[#1]

Hello All,

Please I have problem in pivot chart, I have three dimensions are years and months and days

and I have over 15 expressions fields so I want when I click on any value field I want to get

list of values for this field but unfortunately I cant click to any field else you can click on Dimension

only. How can I resolve this issue?

[Gysbert_Wassenaar · Accepted solution]

If you click on a value in an expression column then all the dimension values for that row will get selected. You cannot select a value in an expression column. The only way to get around that (not recommended) is to turn the expression into a calculated dimension.