5 Replies Latest reply on May 4, 2019 5:11 AM by Jim Dehner

Market share % calculation, filter is not working for other sheets

Hi All,

I have used a table calculation to compute the market share %.

SUM([Value]) / TOTAL(SUM([Value (]))

When I am using the Brand filter it showing 100% for each Brand,

then I have also created a Brand filter below which is working fine but this filter is not applying to other sheets.

Please suggest how to do that.

I can't upload workbook because it is too heavy.

Regards

Sunil

• 1. Re: Market share % calculation, filter is not working for other sheets

we see hundreds of questions daily and try to respond to each of them - don't need to have different people duplicating the task

Jim

• 2. Re: Market share % calculation, filter is not working for other sheets

Hi,@jim

I have tried your solution, but it is showing the only % for that Brand. I need % for that Brand in terms of total of 100%.

I have attached workbook in the 1st sheet I have done my calculation but the brand filter is not working for others sheet.

In the 2nd sheet, I have used your solution.

My question is Market share % should be not more than 100% and my calculation for all the brand must their % contribution in the 100% market share.

• 3. Re: Market share % calculation, filter is not working for other sheets

you submitted a twb workbook without the data - you need to post twbx workbook with the data included

this is why we want the book in the first place - play with the lod and and brand before the colon -

or are there other surprises in the book

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.

• 4. Re: Market share % calculation, filter is not working for other sheets

Hi jim,

PFA workbook

• 5. Re: Market share % calculation, filter is not working for other sheets

I am not clear on what you want - I have interpreted your question to mean that for each period (Y/M) you want to determine the percentage each brand contributes to the total for that period only

and further you want to be able to filter the brands but NOT change the percent of that brand to the total

if that is what you want see the attached

this formula   - note the lod can be used on any sheet unlike a table calc

returns this when all the brands are included - note i do this in a text table so you can see what is going on

when filtered for a single brand this is what it returns

i am gone the rest of the day - if this is not what yo want play with the dimensions in the LODs to meet your expectations

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.

1 of 1 people found this helpful