3 Replies Latest reply on Dec 2, 2016 5:44 AM by Shinichiro Murakami

# How to Distinguished 4 measures by 2 sets

Hi Friends,

I have 4 Measures: Actual Sales, Target Sales, Actual Profit, Expected Profit. I want to make overlapping chat by two group one is Sales and another is Profit with one dimension Quarter. Kindly Help me to solve this problem.

PFB my expected result:

Regards,

Tulu

• ###### 1. Re: How to Distinguished 4 measures by 2 sets

Good luck!

Timothy

1 of 1 people found this helpful
• ###### 2. Re: How to Distinguished 4 measures by 2 sets

Hi Timothy,

As per the Requirements, We should not reshape the data set like pivoting the tables. We have to find one solution without pivoting the tables.

Thanks

1 of 1 people found this helpful
• ###### 3. Re: How to Distinguished 4 measures by 2 sets

Tulu,

I think this ca be alternate solution in a case your version >= 9.3

The key is "Unioin"

Edit data source.

if [Table Name]= "Sheet1" then "Act Profit"

elseif [Table Name]= "Sheet11" then  "Act Sales"

elseif [Table Name]= "Sheet12" then  "Tgt Profit"

elseif [Table Name]= "Sheet13" then  "Tgt Sales"

end

[Measure ]

if [Table Name]= "Sheet1" then [Act Profit (Union)]

elseif [Table Name]= "Sheet11" then  [Act Sales (Union)]

elseif [Table Name]= "Sheet12" then  [Tgt Profit (Union)]

elseif [Table Name]= "Sheet13" then  [Tgt Sales (Union)]

end

[Act/Tgt]

else "Tgt" end

[Sales/Profit]