
Not applicable
2016-08-15
10:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to calculate the % of growth YTY.
Please find the attached QVW.How can I calculate the % of growth (Inccrase or decrease) of Revenue from Year to year ?
Thanks much.
2,234 Views
1 Solution
Accepted Solutions

MVP
2016-08-15
10:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
1,878 Views
3 Replies

MVP
2016-08-15
10:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try like this:
Sum(Revenue)/Above(Sum(Revenue)) - 1
1,879 Views


Creator II
2016-08-15
10:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Slight change in above expression if you want show % growth while selecting single year
Aggr(Sum({1} Revenue)/Above(Sum({1} Revenue)) - 1,Year)

MVP
2016-08-15
10:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Or this, if you need to avoid Aggr() function
(Sum({1}Revenue)/Above(Sum({1}Revenue)) - 1) * Avg(1)
