Hey Dave!

I would suggest uploading atleast a few sample rows of your data. Probably if there are other fields, the solution could hinder based on whats on the view. I am not sure running_sum would work because the values would change if the measure value is sorted vs. not sorted. Customers making up 80% of the total revenue would change I would assume.

Pooja.

I'm not sure where you have trouble regarding LOD?

Here is a sample.

[Sales Share %]

{fixed [Client] :sum([Sales])}/{fixed : sum([Sales])}

Top 80% In/Out

if RUNNING_SUM(sum([Sales Share %]))<=0.8 then "IN" else "OUT" END

I'm not sure about your comment of LOD part?

Thanks,

Shin

9.0 attached

That's a good question, let me try.

Thanks,

Shin

OK, finally done.

You can visit here Vizible Difference: Binning Aggregates for Histogram and Aggregate Distributions

But quite a bit tricky.

Need to use window_sum, window_count and use "hide header" technique.

The point here is we cannot remove "Client" from the Marks because this is the key to determine the Top 80%, IN/OUT.

So we need to show a certain client's line as a representative of each category.

Then flag that client and hide others.

These are story line of the whole procedure.

Put [Client] in Marks and sort

Create calculated filed and set Set Default as below.

[window_sales]

case [Top 80% In/Out]

when "IN" then window_sum(if [Top 80% In/Out]="IN" then sum([Sales]) end)

when "OUT" then window_sum(if [Top 80% In/Out]="OUT" then sum([Sales]) end)

END

[Window_count]

case [Top 80% In/Out]

when "IN" then window_count(if [Top 80% In/Out]="IN" then count([Client]) end)

when "OUT" then window_count(if [Top 80% In/Out]="OUT" then count([Client]) end)

END

Put two fields into Measure Values and edit table calculation

One more calculated field

[Client Flag]

IF First()=0 OR [Top 80% In/Out]!=lookup([Top 80% In/Out],-1)

THEN [Window_Sales]

ELSE NULL

END

Then hide Null from Client Flag. (Not exclude, just hide)

Then hide headers.

Enjoy !!!!

Thank you ,

Shin

9.0 attached.