Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Geniuses,
I have the below data
ACCOUNT_LABEL | HCBU | HCEntity | HCMonth | HCScenario | HCTypes | HCView | HCYear | Headcount |
HC1000T | 1215000 | MDCMGMT | Jan | Actual_Interim | Emiratis | YTD | 2015 | 1 |
HC1000T | 1215000 | MDCMGMT | Jan | Actual_Interim | Emiratis | YTD | 2015 | 4 |
HC1000T | 1215000 | MDCMGMT | Jan | Actual_Interim | Expats | YTD | 2015 | 2 |
HC1000T | 1215000 | MDCMGMT | Jan | Actual_Interim | Expats | YTD | 2015 | 4 |
HC1000T | 1215000 | MDCMGMT | Jan | Actual_Interim | TotalHeadCount | YTD | 2015 | 3 |
HC1000T | 1215000 | MDCMGMT | Jan | Actual_Interim | TotalHeadCount | YTD | 2015 | 8 |
HC1000T | 1331000 | MDCMGMT | Jan | Actual_Interim | Emiratis | YTD | 2015 | 25 |
HC1000T | 1331000 | MDCMGMT | Jan | Actual_Interim | Expats | YTD | 2015 | 12 |
HC1000T | 1331000 | MDCMGMT | Jan | Actual_Interim | TotalHeadCount | YTD | 2015 | 37 |
HC1000T | 1425600 | MDCMGMT | Jan | Actual_Interim | Emiratis | YTD | 2015 | 72 |
HC1000T | 1425600 | MDCMGMT | Jan | Actual_Interim | Expats | YTD | 2015 | 77 |
HC1000T | 1425600 | MDCMGMT | Jan | Actual_Interim | TotalHeadCount | YTD | 2015 | 149 |
HC1000T | 1425800 | MDCMGMT | Jan | BudgetUpdated | Emiratis | YTD | 2015 | 26 |
HC1000T | 1425800 | MDCMGMT | Jan | BudgetUpdated | Expats | YTD | 2015 | 38 |
HC1000T | 1425800 | MDCMGMT | Jan | BudgetUpdated | TotalHeadCount | YTD | 2015 | 64 |
HC1000T | 1713000 | MDCMGMT | Jan | BudgetUpdated | Emiratis | YTD | 2015 | 17 |
HC1000T | 1713000 | MDCMGMT | Jan | BudgetUpdated | Expats | YTD | 2015 | 24 |
HC1000T | 1713000 | MDCMGMT | Jan | BudgetUpdated | TotalHeadCount | YTD | 2015 | 41 |
I am using the formula for Emiratis actual values =num(Sum({<HCMonth = {$(=vMonth)},HCScenario={'Actual_Interim'},HCTypes={'Emiratis'},YEARID = {$(=YearVariable)}>} Headcount) ,'#,##0;(#,##0)')
Expats actual values =num(Sum({<HCMonth = {$(=vMonth)},HCScenario={'Actual_Interim'},HCTypes={'Expats'},YEARID = {$(=YearVariable)}>} Headcount) ,'#,##0;(#,##0)')
Emiratis Budget values =num(Sum({<HCMonth = {$(=vMonth)},HCScenario={'BudgetUpdated'},HCTypes={'Emiratis'},YEARID = {$(=YearVariable)}>} Headcount) ,'#,##0;(#,##0)')
Expats actual values =num(Sum({<HCMonth = {$(=vMonth)},HCScenario={'BudgetUpdated'},HCTypes={'Expats'},YEARID = {$(=YearVariable)}>} Headcount) ,'#,##0;(#,##0)')
Now I want the stacked bar chart in which one bar show actual Emirati and expats values and the other bar show Budget values of emirati and expacts
Attached is the pic how graph should look like
I recommend to remove HCScenrio and HCTypes from the expressions completely, and use these fields as dimensions. It will be easy after that to get a stacked bar chart.