en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Sachy123  
#1 Posted : Monday, March 5, 2018 2:24:51 PM(UTC)
Sachy123
Rank: Newbie

Groups: extranet\Forum
Joined: 3/5/2018(UTC)
Posts: 2

UserPostedImage


How can I have the report to show data in the following monthly order

Nov - 17
Dec - 17
Jan -18
Feb -18
Mar -18
Ole  
#2 Posted : Monday, March 5, 2018 2:58:53 PM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 448

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.

UserPostedImage Ole Dyring
Sachy123  
#3 Posted : Monday, March 5, 2018 3:06:09 PM(UTC)
Sachy123
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)
Ole  
#4 Posted : Monday, March 19, 2018 10:45:44 AM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 448

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.

UserPostedImage Ole Dyring
Users browsing this topic
Anonymous
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.

Notification

Icon
Error

We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.

ok