Click on Pivot Table click on expression current selection show others field

[nicholas5141]

!Hi All,

When I click on pivot table expression it show other fields on current selections.

Is there anything I can do to fix it?  As I want to make it consistent when user click on expression value current selections should show the selected value/field only.

Screenshot & Sample Apps Attached

Thanks you

[jonas_rezende]

Hi, Nic Nic.

I think didn't understand your dubit. Anyway, I saw that  the field name was wrong in the [TOTAL] expression, instead of Sum(Total).  Fixed!

The simulation in the current selection of Dimension and Expression fields worked as selected.

What do you want to achieve with the result?

[Anil_Babu_Samineni]

Me too,

I don't know why are you taking expression as Sum(Total) --> There is no Total Field ....

Please send me the required Exact O/P

[jonas_rezende]

The table TMP contains two fields: Name and Total. In the upload filed by Nic Nic.

[nicholas5141]

Hi sorry qvw updated!

[nicholas5141]

Hi sorry qvw updated!

[nicholas5141]

Hi sorry qvw updated!

[jonas_rezende]

Hi, Nic Nic.

The object current selections shows the value and name of the existing fields in the data model. An expression is an  aggregate function, where the field is passed to a function. Ex.: Sum(), AVG(), and others. So when the selected object appears in the available dimensions in your chart, like:

1. Selection  in dimension Customer, appears name and value Customer;
   
2. Selection in dimension Product, appers name and value Product;
   
3. Selection in expression, appears all the dimensions to the value chosen.
   

Hope this helps!

[nicholas5141]

Hi the problem i facing is point 3

3. Selection in expression, appears all the dimensions to the value chosen.

Is there any way to prevent it? or any setting that I can change? So when user click on expression current selection is show expression clicked value / expression only?

Thanks

[jonas_rezende]

Hi, Nic Nic.

If there is any alternative, unfortunately, I don't know.

Regards,

Jonas Melo.