Create category field with two sub fields

[lessassy]

Hello,

I have two measure that i want to put into a pie chart 

SUM({<SS_TYP_MVT_CD = 'Entry', MOT_MVT_CD = {'EMB_TKP'}>}MEASURE1)
SUM({<SS_TYP_MVT_CD = 'Entry', MOT_MVT_CD = {'EMB_AOV'}>}MEASURE1)

Basically i want to have displayed the percentage for the two measures.

I want to create one category that incorporate the two measures .

Example :

Category A

=>  SS_TYP_MVT_CD = 'Entry', MOT_MVT_CD = 'EMB_TKP' as Cat1

=> SS_TYP_MVT_CD = 'Entry', MOT_MVT_CD = 'EMB_AOV' as Cat2

Basically I want to create a category that have Cat1 and Cat2 as one category so i could display the percentages in the pie chart.

Thanks in advance

Measure1 percentage = P

[QFabian]

Hi @lessassy , i recommend to you, take this to script , like this:

Data:

'Cat1'  as Category,

SUM(MEASURE1)  as Measure

From yoursourcedata

Where

SS_TYP_MVT_CD = 'Entry' and

MOT_MVT_CD = 'EMB_TKP'

Group By [your fields for agrupation];

;

Load

'Cat2'  as Category,

SUM(MEASURE1)  as Measure

From yoursourcedata

Where

SS_TYP_MVT_CD = 'Entry', and

MOT_MVT_CD = 'EMB_AOV'

Group By [your fields for agrupation];

Then creates a chart using the new dimension 'Category'

[Kushal_Chawda]

@lessassy  try below

Create pie chart with below dimension and measure

Dimension:

= valuelist('Cat1','Cat2')

Measure:

=Pick(Match(valuelist('Cat1','Cat2'),'Cat1','Cat2'),
SUM({<SS_TYP_MVT_CD = {'Entry'}, MOT_MVT_CD = {'EMB_TKP'}>}MEASURE1)
SUM({<SS_TYP_MVT_CD = {'Entry'}, MOT_MVT_CD = {'EMB_AOV'}>}MEASURE1))