Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Growth percentage in bar chart
Migrateduser
<p>Hi,</p>
<p> </p>
<p>I have a time dimensional sales data for 3 years. I am able to display 3 years sales in a bar chart. I also need to display the growth percentage in secondary axis, but I am not sure how to calculate this value, because I need to calculate using the values in the rows rather columns. My data structure is like,</p>
<p> </p>
<p>Year|Sales<br>
13-14|100<br>
14-15|210<br>
15-16|111</p>
<p> </p>
<p>My growth formula is (currentrowvalue - previousrowvalue)/previousrowvalue and calculation should start from 2nd row only.</p>
<p> </p>
<p>FYI. I do not have the growth percentage as a value in the database, I need to calculate it on the fly.</p>
<p> </p>
<p>Kindly help.</p>
Find more posts tagged with
Comments
There are no comments yet