Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following field data that load from excel:
Initiative Category, Project Status, Opex Total
I want to display the data in a stacked bar chart as something like the following:
1. Y axis as the sum of opex total
2. X axis to create a group "Opex FY13" that contains all the Initiative Category and Project Status
3. Legends that display different colors for Intiative Category and Project Status
How should I construct the script and create the bar chart?
Thank you
LOAD * INLINE [
Initiative Category, Project Status, T&O Functional Unit, Capex, Opex, Ownership
BU Funded Initiative, In Progress, IBG Tech, 20, 45, 23
Technology and Operations Funded Initiative, In Progress, IBG Tech, 20, 26, 52
EOS Initiative, In Progress, IBG Tech, 40, 25, 63
BU Funded Initiative, Cancelled, TMPB Tech, 30, 32, 13
EOS Initiative, Completed, TMPB Tech, 50, 62, 42
];
Hi please refer to this sample here i have used the set analysis concept .
Please clarify the dimention i used in my chart .i have takent it according to me you can take what you want .
Hope it help!!
ok thanks. it seems like there is no way to create a new dimension on the fly.