 Rank: Newbie
Groups: extranet\Forum
Joined: 3/5/2018(UTC)
Posts: 2
|
 How can I have the report to show data in the following monthly order Nov - 17 Dec - 17 Jan -18 Feb -18 Mar -18
|
|
|
|
|
|
 Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 514
|
The Demo data doesn't support that format. Nor can you tweak the chart labels to show it differently - unfortunately.
Swapping Years and Months in your object's source data definition will probably produce the best result. (Try Dimension axis / Labels / Angled up).
BR / Ole |
Ole Dyring |
|
|
|
|
|
Rank: Newbie
Groups: extranet\Forum
Joined: 3/5/2018(UTC)
Posts: 2
|
Awesome!! Thanks it worked,
How do I now show yearly running total in the bar chart?
Sum (all the costs in that year)
|
|
|
|
|
|
Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 514
|
Supposed that you now have Year and Month on the same axis, you could now make running (accumulated) costs like this:
sum(d1, d1:0, m1)
This would accumulate your data regardless of year. If you want the accumulation to "restart" for each year, the syntax should be slightly modified:
sum(d1, d1:0(s), m1) ... (summing up among siblings)
BR / Ole |
Ole Dyring |
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.