Как посчитать долю от суммы категории из одной таблицы?

Question

Как посчитать долю от суммы категории из одной таблицы?

Eremina, Anastasia 21

Привет.
Скажи есть способы отразить в одной таблице процентную долю продукта от суммы всей категории, (а не от суммы всех продуктов), если у меня много категорий и очень много продуктов?
Пример таблицы 45588-%D0%B2%D0%BE%D0%BF%D1%80%D0%BE%D1%81.jpg

Например, я хочу знать % долю Gordons от суммы всех продуктов категории Gin, ниже я хочу увидеть % долю baileys от суммы Liqueur - как сделать такую таблицу?

Accepted answer

1 additional answer

Your answer

Answer 1

Anonymous

QnA forums are currently English only. They're actively answering question in dedicated forums here.
https://social.technet.microsoft.com/Forums/ru-ru/home

--please don't forget to Accept as answer if the reply is helpful--

Answer 2

Hi @Eremina, Anastasia

To help others, could you please change the title of your post with something like: How do I calculate the percentage of Product by Category?

Bing translation of your post:
Tell me there are ways to reflect in one table a percentage of the product from the amount of the entire category, (rather than the amount of all products) if I have many categories and a lot of products?
For example, I want to know a % share of Gordons from the sum of all Gin category products, below I want to see a % share of baileys from the amount of Liqueur - how to make such a table?

Assuming myTable as below on the left side (picture truncated):

3 measures:

TotalProduct =SUM(myTable[Sell-Out Value])
TotalCategory =CALCULATE([TotalProduct],ALLEXCEPT(myTable,myTable[Category]))
Product %age =DIVIDE([TotalProduct],[TotalCategory],0)

Corresponding Excel sample is available here

If this solves your problem please mark this reply as answer to help others. Otherwise, if I misunderstood what you want to acheive please post an example of the expected result. Thanks

Share via

Как посчитать долю от суммы категории из одной таблицы?

1 additional answer

Your answer