# Cumulative values on dimension **URL:** \ **Category:** Product Ideas\ **Created:** [June 19, 2019, 11:10am UTC](https://pug.phocassoftware.com/t/cumulative-values-on-dimension/1080 "2019-06-19T11:10:37Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![JonKemp](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/jonkemp/32/334_2.png) [@JonKemp](https://pug.phocassoftware.com/u/JonKemp)\ **Post date:** [June 19, 2019, 11:10am UTC](https://pug.phocassoftware.com/t/cumulative-values-on-dimension/1080/1 "2019-06-19T11:10:37Z")
Hi all, I raised this in tips and Tricks in Oct 18 [here](https://pug.phocassoftware.com/t/cumulative-on-dimension/758/2) and looks like Phocas is unable to perform the following: Can the grid/chart view have included an optional cumulative value based on dimension and period being used. This would need to be standard functionality without using custom mode (as this needs to be on a dashboard using the date range options)? You can do cumulative at the summary level (overall) , however, when you change to view on a dimension, this is no longer present. **Example of issue** We want to see cumulative sales by top 10 customers. The user wants to select their own date ranges on the dashboard so both the cumulative amounts and associated data is of that Period range. Custom mode would not work as the date ranges are not variable to date range control within the dashboard. Here is an example of the output what we want: ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/f8ae94658515c3e014ac303bcd7afd0dfa0aec64.png) Each line is the top 10 customers (restricted by widget) from the customer dimension and cumulatively adds each period. As mentioned this can be achieved manually using custom mode as @aaron.roma kindly pointed out on the above tips and trick post , it does not appear possible using standard functionality. This would be a powerful addition to dashboards. Thanks, Jon. ---
**Author:** ![StuartH](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/stuarth/32/394_2.png) [@StuartH](https://pug.phocassoftware.com/u/StuartH)\ **Post date:** [June 19, 2019, 3:54pm UTC](https://pug.phocassoftware.com/t/cumulative-values-on-dimension/1080/2 "2019-06-19T15:54:01Z")
Looking at it I’d agree - there is no option to make it cumulative like this. My suggestion would be to make this an option in the type from a Grid setup perspecitve rather than making it a chart option as that gives the option for both a table or a chart. ---
**Author:** ![JonKemp](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/jonkemp/32/334_2.png) [@JonKemp](https://pug.phocassoftware.com/u/JonKemp)\ **Post date:** [June 26, 2019, 7:17am UTC](https://pug.phocassoftware.com/t/cumulative-values-on-dimension/1080/3 "2019-06-26T07:17:08Z")
Absolutely, it all starts in the grid 🙂 ---
**Author:** ![anon33838874](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@anon33838874](https://pug.phocassoftware.com/u/anon33838874)\ **Post date:** [July 4, 2019, 12:21am UTC](https://pug.phocassoftware.com/t/cumulative-values-on-dimension/1080/4 "2019-07-04T00:21:49Z")
Hi @JonKemp I’ve logged this as a suggestion. If it was an option on the grid, how do you suggest we display the data? An appended column after each period column? Or each period column would show a cumulative value? ---
**Author:** ![JonKemp](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/jonkemp/32/334_2.png) [@JonKemp](https://pug.phocassoftware.com/u/JonKemp)\ **Post date:** [July 4, 2019, 8:16am UTC](https://pug.phocassoftware.com/t/cumulative-values-on-dimension/1080/5 "2019-07-04T08:16:51Z")
> [@anon33838874](#): > > If it was an option on the grid, how do you suggest we display the data? An appended column after each period column? Or each period column would show a cumulative value? Hi @anon33838874, A good question! I think the below formats should be used: Period Mode: ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/373ba1daef9f4b271f29642b8f013ac75ebcad7e.png) Possibly a new “Period Cumulative” Mode: ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/c533283db82a304ace66c6581ffb73fd8212cea3.png) The charts then can choose from either cumulative value or total. Which would result in the following line graph: ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/b1ca9157bcb911792c338aef0181376b371e2464.png) Hope this helps. Kind Regards, Jon ---
**Author:** ![anon33838874](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@anon33838874](https://pug.phocassoftware.com/u/anon33838874)\ **Post date:** [July 11, 2019, 5:37am UTC](https://pug.phocassoftware.com/t/cumulative-values-on-dimension/1080/6 "2019-07-11T05:37:01Z")
That looks like a good way of displaying it @JonKemp. Thanks for your input.