Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am creating a burn down chart using the following expression:
sum(total Hours)-RangeSum(Above(TOTAL Sum(Hours), 0, RowNo(TOTAL))).
and Quarter as dimension
I am getting the required result, but I want the chart to display also the sum of hours (sum Total Hours) for all periods.
For example, in TableCapture.PNG, the total appears in the expression column (1382).
I want the same total to appear as starting point in ChartCapture.PNG . Is it possible?
I tried to use "Show Total" in dimension limit but it didn't work
Thanks,
Karin
So you just want to show the number on the chart but not linked to your dimensions/expressions?
You can add the expression as text here:
You can move it to where you want it by holding down CTRL+SHIFT (a red border should show around it), and then you can click and drag it to where you want it (while still holding down CTRL+SHIFT).