Running total (no dates)

Spencer_2

New member
Joined
Nov 29, 2016
Messages
13
Reaction score
0
Points
0
I have a list of geographies with a sales value. There are 11 other columns that provide further details on these geographies. Products sold, type, flavor, etc, etc.

I need a Running total of sales volume that will adjust based on any filters selected. I have a Measure that is calculating the % of total sales by geography against total sales for a given selection.

If i can get a running total, then adjust my % of Sales measure I can then use the Switch function to dynamically create a label for Top 80% of sales and all remaining dynamically.

Problem is I cannot get the "RUNNING TOTAL" to work with all the different column in this file.

As usual... any and all help greatly appreciated.

Spencer
 
Hi Spencer,

Just clarifying exactly how your running total is defined...
Is your running total always calculated on the 'geography' column, in ascending order of sales by geography?

If so then it is similar to this post (read the comments):
http://exceleratorbi.com.au/cumulative-running-total-based-on-highest-value/

Otherwise, could you give an example what you expect?

Cheers,
Owen
 
Back
Top