
1. Re: Percentage Calculation in Graph
John Sobczak Mar 29, 2018 10:20 AM (in response to Albert Dorfman)1 of 1 people found this helpfulCreate an LOD calc for the total sales call it LOD Total Sales by Year: {fixed [Year] : sum([Sales]) }
Then create another calc using the above calc:
Sum([Sales])/Sum([LOD total Sales by Year])

2. Re: Percentage Calculation in Graph
Deepak Rai Mar 29, 2018 10:20 AM (in response to Albert Dorfman)(EcommerceSales)/{FIXED Year:Sum(Sales)}

3. Re: Percentage Calculation in Graph
Albert Dorfman Apr 2, 2018 7:51 AM (in response to John Sobczak)Hey John,
Thanks for the answer, this is exactly what I was looking for.; however, I'm still having an issue.
I did what you said, but I'm getting the following graphs:Evidently the number of records changes every year (bottom graph), but the percentage graph (top graph) stays the same, when it should be changing.
The top graph is made up of the following calculations:
Calculation 1: {fixed[Year]: SUM([Number of Records])}
Calculation 2: SUM([Number of Records]) / SUM([Calculation1])
I also have an ecommerce filter on here as you can see in the left. In plain english, here's what I want to happen for each year (example given for 2009)
Ecommerce sales in 2009 / total sales in 2009
Any help would be greatly appreciated
Thanks!