
1. Re: How to, LOD for ratio of ratio
Deepak Rai Jul 5, 2018 1:51 PM (in response to jon rios)SUM({fixed [Category], datepart('weekday',[Order Date]): sum( [Sales])})/SUM({fixed [Category]:SUM([Sales])})

2. Re: How to, LOD for ratio of ratio
jon rios Jul 6, 2018 8:21 AM (in response to Deepak Rai)i came up with this and it works.... but since i am not good with LOD I was wondering if there is a more efficient way to do this... this took 3 calculations. let me know, thanks
Step 1. % of Total (= weekday/category % of total )
{fixed [Category], DATEPART('weekday',[Order Date]): sum([Sales])}
/
{ fixed DATEPART('weekday',[Order Date]): SUM([Sales]) }
Step 2. Category % (= category % of total)
{fixed [Category]: SUM([Sales])}
/
{ SUM([Sales]) }
Final calculation in View, ratio of ratio (=% of Weekday/Category to Category % of total)
[% of Total] / [Category %]

3. Re: How to, LOD for ratio of ratio
Deepak Rai Jul 6, 2018 8:59 AM (in response to jon rios)1 of 1 people found this helpfulI think, This is OK as per your Requirement as you need to calculate 2 different Calcs. Another way to do same is
SUM({fixed [Category], DATEPART('weekday',[Order Date]): sum([Sales])}/{ fixed DATEPART('weekday',[Order Date]): SUM([Sales]) })/SUM({fixed [Category]: SUM([Sales])}/{ SUM([Sales]) })
Thanks
Deepak
Please Close The Thread