1 Reply Latest reply on Feb 12, 2016 6:16 AM by Shinichiro Murakami

# Aggregating different measures using different dimensions

Here is my requirement:

I have two measures: X, Y and two dimensions: A, B.

A and B are actually same dimensions but across different time period.So, discrete values in A and B are same.

Now, I am calculating YoY with X and Y and the value is to be displayed for each discrete value of A/B and not finding any way to do so in Tableau.

X aggregated as per A.

Y aggregated as per  B.

Use X and Y aggregations in one formula. Any workarounds?

• ###### 1. Re: Aggregating different measures using different dimensions

Aritra

I don't understand your issue, well but guess below?  // Overview: Level of Detail Expressions

[X of Only A ]

{fixed:sum(if [Year]=2015 then [X] end)}

[X of Only B]

{fixed:sum(if [Year]=2016 then [X] end)}

[Y of Only A]

{fixed:sum(if [Year]=2015 then [Y] end)}

[Y of Only B]

{fixed:sum(if [Year]=2016 then [Y] end)}

Thanks,

Shin

9.0 attached.