Hi all, Is there a way to produce a cumulative line chart split by dimension? 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, I cannot see a w…

Hi Tom, Summary mode would loose the customer dimension name, for us to see the top 10 cumulative on a chart. I.e. this is what we want to see. [image]

@JonKemp Have you thought about doing this in Custom mode? I just threw a quick test together real quick, and here’s the results: [Cust%20Graph] I just used 6 months, but you could extend it out for the year. I used Custom mode to create each column, each one having a custom month period using…

Hi @aaron.roma , Thanks for the reply and the, excellent workaround. however, as much as I love the custom mode, on a dashboard we loose the ability to use the date criteria on the dashboard (unless I don’t know something?) . I.e. ideally the dashboard wants to use standard widget functionality an…

Ah… you got me there. I tried! :smile:

thanks @aaron.roma , that made me chuckle :smile: But none the less you have provided a valuable suggestion!

Cumulative on dimension?

Ask the Community

tom.falter November 4, 2018, 6:11pm 2

@JonKemp - have you tried using the Summary to achieve this after focusing on your top 10 customers?

Cumulative values on dimension

Topic		Replies	Views
Cumulative values on dimension Product Ideas	5	1424	July 11, 2019
Reporting on Aggregate Totals Ask the Community	4	1151	March 24, 2020
Represent records with each other Ask the Community	3	1257	May 25, 2019
Monthly Comparison in a graph Ask the Community	2	1180	July 11, 2019
Toogle of the Cumulative columns in the grid Product Ideas	1	413	July 3, 2023

Cumulative on dimension?

Related topics