I need to select Absolute and realative (%) in the same chart

[#1]

Hi,

I need to show absolute and realtive values in the same chart. Realtive mean (%) values how this can be achieved. I have a list box taht showas Absolute or relative for selecting.

Nanda.

[kji]

Assuming you want to show it as Value on Datapoints, make your expression something like:

Dual( Sum(Sales) & ' (' & Num(Sum(Sales) /Sum(TOTAL Sales) ,'0.00%') & ')', Sum(Sales) )

[#3]

Something like this

[#4]

Hi,

I did not explain clearly.My apologies. I do not want in the same chart but in different chart. I have to create a list box and when user selects absolute it should show numbers and, it Relative is selected it should show percentages(%) . I hope I expalined this time atleast.

Thanks again.

Nanda.

[#5]

Hi,

I did not explain clearly.My apologies. I do not want in the same chart but in different chart. I have to create a list box and when user selects absolute it should show numbers and, it Relative is selected it should show percentages(%) . I hope I expalined this time atleast.

Thanks again.

Nanda.

[#6]

A simple solution is to have two charts - one on top of the other and then use conditional show to switch between them based on the selection.

So graph 1 will show relative expression and graph 2 will show absolute expression. Simply enter the following in the conditional show:

=only(field name) = 'Relative' for graph 1

=only(field name) = 'Absolute' for graph 2

That should work.

[#7]

Here it is