Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Fiscal Period | 1 | 2 | 3 | Total |
---|---|---|---|---|
2012 Actual / Forecast 11+1 | 1629 | 1688 | 1675 | 1202 |
Thanks in advance for any guidance!
PS: the varCurrType variable is just for showing local currency or dolars figures.
You just have to change the total from "expression total" to "Sum of Rows". Here you go.
I'm not sure if this will help you or not, but I have attached an example of using an if() expression to determine whether to use Sales or Forecast as the data. Then you can use a similar expression in the line color to show which is which.
Rebecca, thank for your suggestion but if you turn your chart into table and add a total for the values, you will face the same issue as me. Your total (according to your numbers) should be 29683, but the table in your example is showing 27064. May be from here you can figurate out what is missing in order to get a total which represent the values in the table.
Again thanks for your reply.
You just have to change the total from "expression total" to "Sum of Rows". Here you go.
Thanks Rebecca!! My only comment is about this is working using a Straight Table and not a pivot table due to the fact that Total Mode is not available in Pivot table. Nevertheless using the "Horizontal" check box in the presentation I can accomodate my Quarters (Your periods) in a horizontal way which is the way that we need. Again thanks a lot for your guidance and help in this topic.