Joined: 13 Jan 2015
Online Status: Offline
Posts: 19
Topic: Cross-tab and Chart issue Posted: 05 Feb 2015 at 4:03am
Hello All,
The image pretty much explains everything.
I need a monthly running total of the data shown. for the below example, "6/2014" is missing and it would have a value of 230 because nothing else was logged during that month.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 05 Feb 2015 at 4:11am
usually the best solution for this is to use a 'calendar table' to left join the rest of your data to. Then you can use the date value from the calendar table to group on or display.
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
IP Logged
