
1. Re: Aggregated Calculations within a Dimension  v10.2
Mahfooj Khan Aug 6, 2018 10:02 AM (in response to Gustav Tollemar)1 of 1 people found this helpfulHi,
You may try something like this,
{FIXED [State],DATETRUNC('year',[Ship Date]): SUM(IF [SubCategory] = "Furnishings" then [Sales] END)}
/
{FIXED [State],DATETRUNC('year',[Ship Date]): SUM(IF [SubCategory] = "Phones" then [Sales] end)}
Let us know if this help.
Mahfooj

2. Re: Aggregated Calculations within a Dimension  v10.2
Deepak Rai Aug 6, 2018 10:13 AM (in response to Gustav Tollemar)1 of 1 people found this helpful 
3. Re: Aggregated Calculations within a Dimension  v10.2
Gustav Tollemar Aug 6, 2018 11:04 AM (in response to Deepak Rai)Thanks, this gives me the correct answer when I have State as level of detail. If I take out [State] and remove it from the dimensionality I still seem to get the same 2.4% instead of the 3.1% I should get from the "example 1" tab. I changed the formula to;
{FIXED DATEPART('year', [Ship Date]):SUM(IF [SubCategory]="Furnishings" THEN Sales END)} /{FIXED DATEPART('year', [Ship Date]):SUM(IF [SubCategory]="Phones" THEN Sales END)}
Am i missing something?

4. Re: Aggregated Calculations within a Dimension  v10.2
Deepak Rai Aug 6, 2018 11:13 AM (in response to Gustav Tollemar)1 of 1 people found this helpfulHi Gustav,
You Need This?:
and Now if you bring State to Filter and add to Context, you would get this for Cali
Thanks
Deepak
If it Helps, Pl mark it Helpful and CORRECT to Close Thread