# Детализация по товарам. Какие еще товары берут при покупке выбранного товара

##### Роль: продуктовый аналитик, маркетолог  
Цель: исследование потребительских предпочтений

Отчет показывает рейтинг товаров, которые берут вместе с выбранным в фильтре товаром

##### Фильтры отчета:

- Сегмент
- Товар
- Рейтинг до (количество позиций) позиций

##### **Пример отчета:**

[![image-1735225699499.png](https://rzn-wb-02.1c-hosting.com/uploads/images/gallery/2024-12/scaled-1680-/image-1735225699499.png)](https://rzn-wb-02.1c-hosting.com/uploads/images/gallery/2024-12/image-1735225699499.png)

<table border="1" cellpadding="0" cellspacing="0" data-sheets-baot="1" data-sheets-root="1" dir="ltr" id="bkmrk-%D0%A2%D0%BE%D0%B2%D0%B0%D1%80-%D0%93%D1%80%D1%83%D0%BF%D0%BF%D0%B0-%D0%9A%D0%B0%D1%82%D0%B5%D0%B3%D0%BE%D1%80"><colgroup><col width="138"></col><col width="127"></col><col width="143"></col><col width="141"></col><col width="134"></col></colgroup><tbody><tr><td>Товар</td><td>Группа</td><td>Категория</td><td>Выручка</td><td>Доля ТО в сегменте</td></tr><tr><td>Товар 1</td><td>Торты</td><td>А</td><td>8 567 806</td><td> </td></tr><tr><td>Товар 2</td><td>Торты</td><td>В</td><td>7 157 065</td><td> </td></tr><tr><td>Товар 3</td><td>Торты</td><td>С</td><td>5 617 947</td><td> </td></tr><tr><td>Товар 4</td><td>Торты</td><td> </td><td>3 503 572</td><td> </td></tr><tr><td>Товар 5</td><td>Торты</td><td> </td><td>3 155 258</td><td> </td></tr></tbody></table>

<table border="1" cellpadding="0" cellspacing="0" data-sheets-baot="1" data-sheets-root="1" dir="ltr" id="bkmrk-%D0%94%D0%BE%D0%BB%D1%8F-%D0%BE%D1%82%D0%BD-%D0%BD%D0%BE-%D0%BE%D0%B1%D1%89%D0%B5%D0%B3%D0%BE-%D0%A2"><colgroup><col width="116"></col><col width="89"></col><col width="108"></col><col width="136"></col><col width="89"></col><col width="89"></col></colgroup><tbody><tr><td>Доля отн-но общего ТО</td><td>Доля покупок отн общ кол-ва</td><td>Списано за покупки</td><td>Списано акционных</td><td>Списано итого</td><td>Выручка с учётом скидки</td></tr><tr><td>6,43%</td><td>3,99%</td><td>именно на этот товар</td><td> </td><td> </td><td> </td></tr><tr><td>5,37%</td><td>2,95%</td><td> </td><td> </td><td> </td><td> </td></tr><tr><td>4,21%</td><td>2,56%</td><td> </td><td> </td><td> </td><td> </td></tr><tr><td>2,63%</td><td>1,79%</td><td> </td><td> </td><td> </td><td> </td></tr><tr><td>2,37%</td><td>1,55%</td><td> </td><td> </td><td> </td><td> </td></tr></tbody></table>

##### Сортировка -  
Группировка -

##### **Расшифровка данных отчета:**

<table cellpadding="0" cellspacing="0" class="xslData;XLSY;v2;5803;BgaAAgAAB6ACAAAB9wgAAAKlEQAAA+MDAAAECwQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEbAAAA+gMAAAAADAANAA4ADwD7AAcAAAD6EgAAAAD7Aj4BAAD6AA8AAAAeBEIERwQ1BEIEPQQ+BEEEQgRMBC4AeABsAHMAeAABFAAAAG8AYwB1AGkAeQB1AGUAawBhAHQAOABqAF8ATQBBAE4AUwBLAFYAMQACKgAAABwEMAQ9BEEEOgQ4BDkEIAASBDAEOwQ1BEAEOAQ5BCAAKABNAEEATgBTAEsAVgApACAAKABtAGEAbgBzAGsAdgBAAHIAYQByAHUAcwAuAHIAdQApAAMCAAAAMgA5AAUUAAAAMgAwADIANAAtADEAMgAtADIANgBUADEANQA6ADAAOAA6ADQANABaAPsAWAAAAPoGDAAAAG8AYwB1AGkAeQB1AGUAawBhAHQAOABqAAcIAAAAMgA2ADYAMQA3ADcANAA0AAkJAAAAOAAxADQANQAzADUAMQA0ADMACwQAAAAxADAANAA5APskAAAAAAAAAAABCwAAAAIGAAAAAAQAAAAAAwAAAAAPAAAAABsAAAAA6AQAAADjBAAAAUUAAAAABh4AAAAQBD0EMAQ7BDgENwQgAD4EQgRHBDUEQgQ+BDIEIAABBAEAAAACAQIDBhIAAABBADIANAA5ADoAQwAyADUAOQACtAAAAAMiAAAAAAEBAgQBAAAAAwQBAAAABAQBAAAABQUAAAAAgLZRQAYBAQMfAAAAAgQCAAAAAwQCAAAABAQCAAAABQUAAAAAAJAcQAYBAQMfAAAAAgQDAAAAAwQDAAAABAQDAAAABQUAAAAAAGljQAYBAQMfAAAAAgQEAAAAAwQEAAAABAQBAAAABQUAAAAAgARmQAYBAQMcAAAAAgQAQAAAAwQFAAAABAQBAAAABQUAAAAAAEgiQBY3AAAAFzIAAAAULQAAAAAIAAAAQQAyADQAOQABBAAAAAAAAAACEgAAAEEAMgA0ADkAOgBDADIANQA5AAsKAAAAAQUAAAAAAIAsQA48AAAAAAXNzMzMzMwxQAEFmpmZmZkZM0ACBc3MzMzMzDFAAwWamZmZmRkzQAQFexSuR+F6HkAFBXsUrkfheh5ADz8AAAABAQkCAQADAQAEBAEAAAAFAQAGAQAIBAEAAAAJBAEAAAAKBFgCAAAAAQELAQAPBGQAAAAQAQARAQESBFgCAAAQBgAAAAABAAEBAAnsAgAAI+cCAAAABgAAkQEAABH4AAAAAAAAAFkBAAAAAAAAAAcOAAAAAAQAAAAAAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAAAIAAAAAAAAR+QAAAAAAAABoAQAAAAAAAAAHDgAAAAAEAAAAAwAAAAAABw4BAAAABQAAAAEAAAAAAAcOAgAAAAYAAAAEAAAAAAAAEfoAAAAAAAAAWQEAAAAAAAAABw4AAAAABwAAAAUAAAAAAAEKAQAAAAIAAAAAAAcOAgAAAAMAAAAGAAAAAAAAEfsAAAAAAAAAWQEAAAAAAAAABw4AAAAABAAAAAcAAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAACAAAAAAAABH8AAAAAAAAAFkBAAAAAAAAAAcOAAAAAAQAAAAJAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAAAoAAAAAAAAR/QAAAAAAAABZAQAAAAAAAAAHDgAAAAAEAAAACwAAAAAABw4BAAAAAgAAAAEAAAAAAAcOAgAAAAMAAAAMAAAAAAAAEf4AAAAAAAAAWQEAAAAAAAAABw4AAAAABAAAAA0AAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAADgAAAAAAABH/AAAAAAAAAFkBAAAAAAAAAAcOAAAAAAgAAAAPAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAABAAAAAAAAARAAEAAAAAAABZAQAAAAAAAAAHDgAAAAAIAAAAEQAAAAAABw4BAAAAAgAAAAEAAAAAAAcOAgAAAAMAAAASAAAAAAAAEQEBAAAAAAAAWQEAAAAAAAAABw4AAAAACAAAABMAAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAAFAAAAAAAABECAQAAAAAAAFkBAAAAAAAAAAcOAAAAAAQAAAAVAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAABYAAAAAAJIBAAUAAAAABwAAAAAMAAAAABsAAAAAqggAAAAPAAAAAwoAAAAiBD4EMgQwBEAEAAcAAAADAgAAACsAAKcAAAADogAAAB0EMAQ3BDIEMAQ9BDgENQQgAEEEPgQ/BEMEQgRBBEIEMgRDBE4ESQQ1BDMEPgQgAEIEPgQyBDAEQAQwBCwAIAA6BD4EQgQ+BEAESwQ5BCAAPwRABDgEPgQxBEAENQRCBDAENQRCBEEETwQgADIEPAQ1BEEEQgQ1BCAAQQQgAEIEPgQyBDAEQAQ+BDwEIAA4BDcEIABEBDgEOwRMBEIEQAQwBAARAAAAAwwAAAATBEAEQwQ/BD8EMAQAlQAAAAOQAAAAEwRABEMEPwQ/BDAELAAgADoEIAA6BD4EQgQ+BEAEPgQ5BCAAPgRCBD0EPgRBBDgEQgRBBE8EIABBBD4EPwRDBEIEQQRCBDIEQwROBEkEOAQ5BCAAQgQ+BDIEMARABC4AIAAVBEEEQgRMBCAAMgQgADoEMARABEIEPgRHBDoENQQgAEIEPgQyBDAEQAQwBCAAABcAAAADEgAAABoEMARCBDUEMwQ+BEAEOARPBAAtAQAAAygBAAAaBCAAOgQwBDoEPgQ5BCAAOgQwBEIENQQzBD4EQAQ4BDgEIABCBD4EMgQwBEAEPgQ+BDEEPgRABD4EQgQwBCAAPgRCBD0EPgRBBDgEQgRBBE8EIABCBD4EMgQwBEAEIAAoAEEAQgBDACAAQQQ1BDMEPAQ1BD0EQgQwBEYEOARPBCkAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgACAAIAAgAAATAAAAAw4AAAASBEsEQARDBEcEOgQwBABJAAAAA0QAAAAhBEMEPAQ8BDAEIAA/BEAEPgQ0BDAENgQgAEEEPgQ/BEMEQgRBBEIEMgRDBE4ESQQ1BDMEPgQgAEIEPgQyBDAEQAQwBAApAAAAAyQAAAAUBD4EOwRPBCAAIgQeBCAAMgQgAEEENQQzBDwENQQ9BEIENQQAhwAAAAOCAAAAIQRDBDwEPAQwBCAAPwRABD4ENAQwBDYEIABBBD4EPwRDBEIEQQRCBDIEQwROBEkENQQzBD4EIABCBD4EMgQwBEAEMAQgAC8AIABBBEMEPAQ8BDAEIAA/BEAEPgQ0BDAENgQgAEEENQQzBDwENQQ9BEIEMAQgACoAIAAxADAAMAAlAAAvAAAAAyoAAAAUBD4EOwRPBCAAPgRCBD0ELQA9BD4EIAA+BDEESQQ1BDMEPgQgACIEHgQAgQAAAAN8AAAAIQRDBDwEPAQwBCAAPwRABD4ENAQwBDYEIABBBD4EPwRDBEIEQQRCBDIEQwROBEkENQQzBD4EIABCBD4EMgQwBEAEMAQgAC8AIAA+BDEESQQwBE8EIABBBEMEPAQ8BDAEIAA/BEAEPgQ0BDAENgQgACoAIAAxADAAMAAlAAA7AAAAAzYAAAAUBD4EOwRPBCAAPwQ+BDoEQwQ/BD4EOgQgAD4EQgQ9BCAAPgQxBEkEIAA6BD4EOwQtADIEMAQAhwAAAAOCAAAAGgQ+BDsEOARHBDUEQQRCBDIEPgQgAD8EQAQ+BDQEMAQ2BCAAQQQ+BD8EQwRCBEEEQgQyBEMETgRJBDUEMwQ+BCAAQgQ+BDIEMARABDAEIAAvACAAPgQxBEkENQQ1BCAAOgQ+BDsEOARHBDUEQQRCBDIEPgQgAD8EQAQ+BDQEMAQ2BAApAAAAAyQAAAAhBD8EOARBBDAEPQQ+BCAANwQwBCAAPwQ+BDoEQwQ/BDoEOAQAlwAAAAOSAAAAGgQ+BDsEOARHBDUEQQRCBDIEPgQgAEEEPwQ4BEEEMAQ9BD0ESwRFBCAAMQQ+BD0EQwRBBD4EMgQgADcEMAQgAD8EPgQ6BEMEPwQ6BDgEIAA/BEAEOAQgAD8EQAQ+BDQEMAQ2BDUEIABBBD4EPwRDBEIEQQRCBDIEQwROBEkENQQzBD4EIABCBD4EMgQwBEAEMAQAJwAAAAMiAAAAIQQ/BDgEQQQwBD0EPgQgADAEOgRGBDgEPgQ9BD0ESwRFBACVAAAAA5AAAAAaBD4EOwQ4BEcENQRBBEIEMgQ+BCAAQQQ/BDgEQQQwBD0EPQRLBEUEIAAwBDoERgQ4BD4EPQQ9BEsERQQgADEEPgQ9BEMEQQQ+BDIEIAA/BEAEOAQgAD8EQAQ+BDQEMAQ2BDUEIABBBD4EPwRDBEIEQQRCBDIEQwROBEkENQQzBD4EIABCBD4EMgQwBEAEMAQAHwAAAAMaAAAAIQQ/BDgEQQQwBD0EPgQgADgEQgQ+BDMEPgQAjQAAAAOIAAAAHgQxBEkENQQ1BCAAOgQ+BDsEOARHBDUEQQRCBDIEPgQgAEEEPwQ4BEEEMAQ9BD0ESwRFBCAAMQQ+BD0EQwRBBD4EMgQgAD8EQAQ4BCAAPwRABD4ENAQwBDYENQQgAEEEPgQ/BEMEQgRBBEIEMgRDBE4ESQQ1BDMEPgQgAEIEPgQyBDAEQAQwBAAzAAAAAy4AAAASBEsEQARDBEcEOgQwBCAAQQQgAEMERwRRBEIEPgQ8BCAAQQQ6BDgENAQ6BDgEALcAAAADsgAAACAAEgRLBEAEQwRHBDoEMAQgAD8EQAQ4BCAAPwRABD4ENAQwBDYENQQgAEEEPgQ/BEMEQQRCBDIEQwROBEkENQQzBD4EIABCBD4EMgQwBEAEMAQgAC0AIABBBEMEPAQ8BDAEIABBBDoEOAQ0BD4EOgQgAD8EQAQ4BCAAPwRABD4ENAQwBDYENQQgAEEEPgQ/BEMEQQRCBDIEQwROBEkENQQzBD4EIABCBD4EMgQwBEAEMAQCBQAAAIEAAAABKAAAAAADAAAAAQEKAQMAAAABAQoCAwAAAAEBCgQDAAAAAQEKBQMAAAABAQoBTwAAAAAMAAAAAQENAAYDAAAAAQEAAQMAAAABAQoCDAAAAAEBDQAGAwAAAAEBAAQPAAAAAQENAAYGAAAAAATMzMwABQwAAAABAQ0ABgMAAAABAQAEVAAAAAULAAAAAAYAAAACAQAAABEFCwAAAAAGAAAAAgEAAAAIBS8AAAAAKgAAAAIBAAAAEgMNAAAAAgEAAwUAAAAAAAAAAAQNAAAAAgEAAwUAAAAAAAAAAAYiAQAAByoAAAABBgMAAAACAQEEBg4AAABDAGEAbABpAGIAcgBpAAkBAQYFAAAAAAAAJkAHNwAAAAEGAwAAAAIBAQQGHgAAAFQAaQBtAGUAcwAgAE4AZQB3ACAAUgBvAG0AYQBuAAYFAAAAAAAALEAHPQAAAAABAQEGBgAAAAAEULAAAAQGHgAAAFQAaQBtAGUAcwAgAE4AZQB3ACAAUgBvAG0AYQBuAAYFAAAAAAAALEAHLgAAAAQGHgAAAFQAaQBtAGUAcwAgAE4AZQB3ACAAUgBvAG0AYQBuAAYFAAAAAAAALEAHPQAAAAABAQEGBgAAAAAEAAD/AAQGHgAAAFQAaQBtAGUAcwAgAE4AZQB3ACAAUgBvAG0AYQBuAAYFAAAAAAAALEAOKQAAAAMkAAAAAQEBBgQAAAAAAgEBBwQAAAAAAwEBCAQAAAAABAEBCQQAAAAAAtQBAAADHgAAAAYEAAAAAAcEAAAAAAgEAAAAAAkEAAAAAAwEAAAAAAMhAAAABgQAAAAABwQAAAAAAwEBCAQBAAAACQQAAAAADAQAAAAAAy0AAAAGBAAAAAAHBAAAAAADAQEIBAEAAAAJBAAAAAAAAQENBgMAAAAAAQAMBAAAAAADLQAAAAYEAAAAAAcEAAAAAAMBAQgEAQAAAAkEAAAAAAABAQ0GAwAAAAABBQwEAAAAAAM2AAAAAQEBBgQBAAAABwQAAAAAAwEBCAQCAAAACQQAAAAAAAEBDQYJAAAAAAEABwEBCAEBDAQAAAAAAzMAAAAGBAAAAAAHBAAAAAADAQEIBAMAAAAJBAAAAAAAAQENBgkAAAAAAQAHAQEIAQEMBAAAAAADMwAAAAYEAAAAAAcEAAAAAAMBAQgEAwAAAAkEAAAAAAABAQ0GCQAAAAABBQcBAQgBAQwEAAAAAAM5AAAAAQEBBgQBAAAAAgEBBwQCAAAAAwEBCAQEAAAACQQAAAAAAAEBDQYJAAAAAAEABwEBCAEBDAQAAAAAAzkAAAABAQEGBAEAAAACAQEHBAIAAAADAQEIBAIAAAAJBAAAAAAAAQENBgkAAAAAAQAHAQEIAQEMBAAAAAAPKAAAABAjAAAAAAQAAAAAAAAABAwAAABOAG8AcgBtAGEAbAAFBAAAAAAAAAAMTgAAAAAiAAAAVABhAGIAbABlAFMAdAB5AGwAZQBNAGUAZABpAHUAbQAyAAEiAAAAUABpAHYAbwB0AFMAdAB5AGwAZQBMAGkAZwBoAHQAMQA2ABE3AAAAADIAAAD6ABEAAABTAGwAaQBjAGUAcgBTAHQAeQBsAGUATABpAGcAaAB0ADEA+wAEAAAAAAAAAAgAAAAAEy8AAAAAKgAAAFQAaQBtAGUAUwBsAGkAYwBlAHIAUwB0AHkAbABlAEwAaQBnAGgAdAAxAA==" id="bkmrk-%D0%A2%D0%BE%D0%B2%D0%B0%D1%80-%D0%9D%D0%B0%D0%B7%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5-%D1%81%D0%BE%D0%BF%D1%83%D1%82" style="width: 781px;"><tbody><tr><td style="width: 191px;">Товар</td><td style="width: 590px;">Название сопутствующего товара, который приобретается вместе с товаром из фильтра</td></tr><tr><td style="width: 191px;">Группа</td><td style="width: 590px;">Группа, к которой относится сопутствующий товар. Есть в карточке товара</td></tr><tr><td style="width: 191px;">Категория</td><td style="width: 590px;">К какой категории товарооборота относится товар (ABC сегментация)</td></tr><tr><td style="width: 191px;">Выручка</td><td style="width: 590px;">Сумма продаж сопутствующего товара</td></tr><tr><td style="width: 191px;">Доля ТО в сегменте</td><td style="width: 590px;">Сумма продаж сопутствующего товара / сумма продаж сегмента \* 100%</td></tr><tr><td style="width: 191px;">Доля отн-но общего ТО</td><td style="width: 590px;">Сумма продаж сопутствующего товара / общая сумма продаж \* 100%</td></tr><tr><td style="width: 191px;">Доля покупок отн общ кол-ва</td><td style="width: 590px;">Количество продаж сопутствующего товара / общее количество продаж</td></tr><tr><td style="width: 191px;">Списано за покупки</td><td style="width: 590px;">Количество списанных бонусов за покупки при продаже сопутствующего товара</td></tr><tr><td style="width: 191px;">Списано акционных</td><td style="width: 590px;">Количество списанных акционных бонусов при продаже сопутствующего товара</td></tr><tr><td style="width: 191px;">Списано итого</td><td style="width: 590px;">Общее количество списанных бонусов при продаже сопутствующего товара</td></tr><tr><td style="width: 191px;">Выручка с учётом скидки</td><td style="width: 590px;">Выручка при продаже сопутствующего товара - сумма скидок при продаже сопутствующего товара</td></tr></tbody></table>