Percentage calc in charts

[#1]

Hi,

I am trying to get percentage calculation in my chart in the attached sample. When I use expression for amount in currency (1st expression), it works but not when in I use expression to calculate revenue percentage for each country compared revenue of USA (2nd expression). If I check out the percentages for individual countries compared to revenue of USA in text box, it displays the values but this is not seen in the chart. Any idea?

Thanks,

[oknotsen]

I downloaded your QVW and I can not find an expression set to show as "relative percentage".

Do you mean the bar chart and if so, which of the two expressions, or the pivot table?

[sunny_talwar · Accepted solution]

Try this:

Sum(Revenue)/Sum(TOTAL {<[Country]={'USA'}>} Revenue)

[vkolasani]

Which Chart are you using?

Thanks,

Venu

[oknotsen]

Is this what you had in mind?

If so, you forgot to actually check "relative".

[vkolasani]

Sum(Revenue)/Sum(Total Revenue) Should also work.

Thanks,

Venu