Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'
@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))