Hi Naila,

Please use this calculation:

SUM([Value Sales])/min(

{ FIXED : sum(if ISNULL([Company]) then [Value Sales] end)})

Then format this field as a percentage, results will be this:

Thanks, I've attached the workbook so that you can take a look.

Mavis

Good morning

please see the attached approach

it uses the following formula

and returns this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

Hi Naila Ahmed,

Ah you have filters, in that case please try this:

SUM([Value Sales])/min(

{ EXCLUDE [Company]  : sum(if ISNULL([Company]) then [Value Sales] end)})

I've added it into your workbook and it looks like it works!

:

Originally I was using a fixed LOD calculation which comes BEFORE any filters are applied. Now I've used an exclude LOD calculation which takes the filters into account

More information on LODs can be found here: Overview: Level of Detail Expressions  and Top 15 Tableau LOD Expressions (Practical Examples)

Thanks, I've reattached the workbook so that you can see how it works.

Mavis

Good morning again

I see you added dimensions to the vis

the way fixed works it will use the dimension to create permutations of the all the combinations

if you take the formula I sent fits and add the dimension in your viz

it will produce this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

Thanks

Glad to help out

Jim