on 2024 Jul 09 1:27 PM
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
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 11 | |
| 6 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.