Displaying calculated fields depending on selection of values in radio button

[#1]

Hello,

i want to create a radio button to select either volume or value and accordingly i want to show only sum (volume) or sum(value) (which are calculated values) in my pivot chart depending on the radio selection . For reference i am attaching the image

example, if i create a list box volume/value with value and volume entity only. and on selection of value , it should show me the highlited sum(Actual(value) only.

[#2 · Accepted solution]

Hi,You can create an inline table having column name as volume/value with values volume and value.Then in the expression tab of the pivot table you can add [volume/value]='volume' in the conditional box(in the top right corner)and make sure you check it.

Repeat the same process for value i.e add [volume/value]='value' .So once you select value in the listbox/radio button,only sum(Actual(value) will be displayed and vice-versa when you select volume.

[ashfaq_haseeb]

Hi,

I would create group for my Expressions.

So that end user can cycle it.

Go to chart properties --> Expression tab --> Select your Second expression and click on group.

Hope it helps.

Regards

ASHFAQ