cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SAC - Chart mixing 2 measures

Deb_D
Participant
0 Likes
544

Hey, 
I have a workforce model.
in my account dimension I have:

1. Labor GL accounts - and I use them with measures as local value, USD, EUR.

2. Statistic accounts - for FTE planning (actual FTE, new hire, termination, expected FTE) which I use with measure FTE (Not Financial)

I want to create a chart showing my expected FTEs, as a line, and my expected salary expenses as columns.
but as it's in 2 measures I'm not able to create the line, or by changing the order of  date&measure I can create a line that is not overlapping the columns - see below

Is there any way to do it?
Thanks

Deb_D_0-1720527885556.png

Deb_D_1-1720527985177.png

 

 

 

 

 

Accepted Solutions (1)

Accepted Solutions (1)

N1kh1l
Active Contributor

@Deb_D 

Use ACCOUNTLOOKUP() or MEASURELOOKUP() to either create a calculated account or calculated measure and then you might be able to bring on same chart.

 

Nikhil

Deb_D
Participant
0 Likes
Thank you Nikhil, I'll try

Answers (0)