Create a load statement for the excel file using the file wizard. You can choose to fill the x-project fields with values from the row above if the cell is empty. And you can enable the CrossTable option so all the Month columns are transformed to a usable form with the Months in a Month field and the KPI values in a Value field. You can then use Month as dimension in the bar chart and select Aug if you want to see only the KPI's of Aug.
Feel free to post the excel file if you aren't able to get the result you want.
Hello, Following your requirement this is how I would do it:
[SLA's of Project],
(ooxml, embedded labels, table is Sheet1);
Sample app is attached
Temp.qvw 151.5 K
It worked, but we also have some conditions and validations
1) I am looking at the change of the color of the graph based on some thresholds for eg. if the Actual is <5% of the SLA Target then the bar graph should be Amber in color, if the Acutal if <10% of the SLA Target the barg graph should be in Red color.
2) Also this will be a continuous data, so we might have month wise columns being added after 'Aug' so how do we populate that. I guess you are using the value '4' in the crosstable function.
For 1) Try something like this on the background colour for the expression
For 2) The 4 is identifying the number of fields preceding the table to be transformed, in other words that is your prj, sub-proj, sub-sub-proj and target. Just keep adding rows for the month in your load statement and it will work fine.