
1. Re: Dimension and Measure in Calculation
nikher verma Mar 19, 2018 12:40 PM (in response to karishma.velisetty.1)Hi Karishma ,
You can do it in many ways , one of them is to create one calculated field and group them as per requirement .
In case you face any issue please add twbx file .
Nikher

2. Re: Dimension and Measure in Calculation
karishma.velisetty.1 Mar 19, 2018 12:54 PM (in response to nikher verma)attached workbook in earlier post. I need to create scatter plot so need two calculations

3. Re: Dimension and Measure in Calculation
nikher verma Mar 20, 2018 5:03 AM (in response to karishma.velisetty.1)Hi Karishma ,
You can do it by using LOD .
just added one calculated field . In case you are not able to open twbx file as I am using 10.5.1
Here what I have done for "Calculation1"

Book1 (1).twbx 14.0 KB


4. Re: Dimension and Measure in Calculation
Zhouyi Zhang Mar 20, 2018 5:48 AM (in response to karishma.velisetty.1) 
5. Re: Dimension and Measure in Calculation
Wesley Magee Mar 20, 2018 11:10 AM (in response to karishma.velisetty.1)I'm not sure of the exact result you're looking for, but here are the two equations you asked for:
Price  A, B, C
IF [Doc type] = "A"
OR [Doc type] = "B"
OR [Doc type] = "C"
THEN [Price]
END
Price D, E
IF [Doc type] = "D"
OR [Doc type] = "E"
THEN [Price]
END
Wesley
If this post assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

6. Re: Dimension and Measure in Calculation
karishma.velisetty.1 Mar 20, 2018 6:13 PM (in response to Zhouyi Zhang)I tried this but i get error " cant compare combined fileds with string values"

7. Re: Dimension and Measure in Calculation
Zhouyi Zhang Mar 20, 2018 7:38 PM (in response to karishma.velisetty.1)so what's your combined fields? can you provide a sample workbook?
ZZ