 Rank: Newbie
Groups: extranet\Customer
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\Customer
Joined: 4/7/2011(UTC)
Posts: 455
|
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 |
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.  Ole Dyring |
|
|
|
|
|
Rank: Newbie
Groups: extranet\Customer
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\Customer
Joined: 4/7/2011(UTC)
Posts: 455
|
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 |
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S. 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.