Forum Discussion

Srinivasacharyulu Daroori's avatar
Srinivasacharyulu Daroori
Copper Contributor
Nov 22, 2017

How to get "Shopping basket" in my Excel 2016

Hi, I have the Data Analysis pack add-in and solver add-in in my Excel 2016. However, I could not find the tab where i can see the "Shopping Basket Analysis" as shown in the microsoft website (http...
Data Analysis
Leon Chen's avatar
Leon Chen
Copper Contributor
Jul 17, 2018

Shopping Basket Analysis is for excel 2010.

I tried to use the tools many times in excel 2016 & 2013 but it doesn't work.

I suggest you to use Shopping Basket Analysis tools in excel 2010.

https://docs.microsoft.com/en-us/sql/2014/analysis-services/shopping-basket-analysis-table-analysistools-for-excel?view=sql-server-2017

Resources