Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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?
Try this:
Sum(Revenue)/Sum(TOTAL {<[Country]={'USA'}>} Revenue)
Which Chart are you using?
Thanks,
Venu
Is this what you had in mind?
If so, you forgot to actually check "relative".
Sum(Revenue)/Sum(Total Revenue) Should also work.
Thanks,
Venu